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 FND_MSG_PUB

Line 169: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

165: -- 'L': This resource is the login user.
166: -- 'T': This resource is defined in territory.
167: g_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
168:
169: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
170: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
172: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
173:

Line 170: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

166: -- 'T': This resource is defined in territory.
167: g_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
168:
169: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
170: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
172: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
173:
174: PROCEDURE Insert_Access_Records(

Line 171: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

167: g_resource_flag_tbl AS_LEAD_ROUTING_WF.FLAG_TABLE;
168:
169: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
170: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
172: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
173:
174: PROCEDURE Insert_Access_Records(
175: p_resource_id IN NUMBER,

Line 172: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

168:
169: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
170: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
171: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
172: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
173:
174: PROCEDURE Insert_Access_Records(
175: p_resource_id IN NUMBER,
176: p_group_id IN NUMBER,

Line 410: FND_MSG_PUB.initialize;

406:
407: -- Initialize message list IF p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
409: THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: -- Debug Message
414: IF (AS_DEBUG_LOW_ON) THEN

Line 415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

428:
429: /* ffang 112800
430: IF FND_GLOBAL.User_Id IS NULL
431: THEN
432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
433: THEN
434: AS_UTILITY_PVT.Set_Message(
435: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
436: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 435: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

431: THEN
432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
433: THEN
434: AS_UTILITY_PVT.Set_Message(
435: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
436: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
437: p_token1 => 'PROFILE',
438: p_token1_value => 'USER_ID');
439: END IF;

Line 465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 534: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 536: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 540: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 542: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 544: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 546: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 548: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 550: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 552: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 554: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 558: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 560: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 562: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 564: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 566: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 570: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 572: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 581: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 611: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 613: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 615: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 620: FND_MSG_PUB.Get (

616: 'last = '||l_assignresources_tbl.last);
617: END IF;
618:
619: IF x_return_status = 'E' THEN
620: FND_MSG_PUB.Get (
621: p_msg_index => FND_MSG_PUB.G_LAST,
622: p_encoded => FND_API.G_TRUE ,
623: p_data => l_data,
624: p_msg_index_out => l_index_out

Line 621: p_msg_index => FND_MSG_PUB.G_LAST,

617: END IF;
618:
619: IF x_return_status = 'E' THEN
620: FND_MSG_PUB.Get (
621: p_msg_index => FND_MSG_PUB.G_LAST,
622: p_encoded => FND_API.G_TRUE ,
623: p_data => l_data,
624: p_msg_index_out => l_index_out
625: );

Line 627: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 641: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 643: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 652: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 684: FND_MSG_PUB.Count_And_Get

680: 'PVT: ' || l_api_name || ' End');
681: END IF;
682:
683: -- Standard call to get message count and IF count is 1, get message info.
684: FND_MSG_PUB.Count_And_Get
685: ( p_count => x_msg_count,
686: p_data => x_msg_data );
687:
688: EXCEPTION

Line 693: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 703: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 755: FND_MSG_PUB.initialize;

751:
752: -- Initialize message list IF p_init_msg_list is set to TRUE.
753: IF FND_API.to_Boolean( p_init_msg_list )
754: THEN
755: FND_MSG_PUB.initialize;
756: END IF;
757:
758: -- Debug Message
759: IF (AS_DEBUG_LOW_ON) THEN

Line 760: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

771: -- Validate Environment
772: -- ******************************************************************
773: IF FND_GLOBAL.User_Id IS NULL
774: THEN
775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
776: THEN
777: AS_UTILITY_PVT.Set_Message(
778: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
779: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 778: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

774: THEN
775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
776: THEN
777: AS_UTILITY_PVT.Set_Message(
778: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
779: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
780: p_token1 => 'PROFILE',
781: p_token1_value => 'USER_ID');
782: END IF;

Line 788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 800: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

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

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

Line 812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

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

Line 845: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 850: FND_MSG_PUB.Count_And_Get

846: 'PVT: ' || l_api_name || ' End');
847: END IF;
848:
849: -- Standard call to get message count and IF count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count,
852: p_data => x_msg_data );
853:
854: END CALL_WF_TO_ASSIGN;

Line 1279: FND_MSG_PUB.initialize;

1275:
1276: -- Initialize message list IF p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean( p_init_msg_list )
1278: THEN
1279: FND_MSG_PUB.initialize;
1280: END IF;
1281:
1282: -- Debug Message
1283: IF (AS_DEBUG_LOW_ON) THEN

Line 1284: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1296: -- ******************************************************************
1297:
1298: IF FND_GLOBAL.User_Id IS NULL
1299: THEN
1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1301: THEN
1302: AS_UTILITY_PVT.Set_Message(
1303: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1304: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 1303: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1299: THEN
1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1301: THEN
1302: AS_UTILITY_PVT.Set_Message(
1303: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1304: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1305: p_token1 => 'PROFILE',
1306: p_token1_value => 'USER_ID');
1307: END IF;

Line 1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1345: FND_MSG_PUB.Count_And_Get

1341: Add_Creator_In_Sales_Team(l_customer_id, l_address_id,
1342: p_sales_lead_id, p_identity_salesforce_id, p_salesgroup_id);
1343: -- Standard call to get message count and IF count is 1,
1344: -- get message info.
1345: FND_MSG_PUB.Count_And_Get
1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data );
1348:
1349: RETURN;

Line 1365: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1385: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1413: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1420: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1454: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1450: OPEN C_Get_Partner_Name(l_referred_by);
1451: FETCH C_Get_Partner_Name INTO l_partner_name;
1452: CLOSE C_Get_Partner_Name;
1453: AS_UTILITY_PVT.Set_Message(
1454: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1455: p_msg_name => 'AS_CM_NOT_DEFINED_FOR_PARTNER',
1456: p_token1 => 'PARTNER_NAME',
1457: p_token1_value => l_partner_name);
1458: END IF;

Line 1465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1492: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1516: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1590: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1601: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1603: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1605: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1607: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1609: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1611: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1613: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1615: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1619: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1621: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1623: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1625: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1627: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1629: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1631: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1635: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1637: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1639: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1641: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1643: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1645: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1647: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1676: FND_MSG_PUB.Get (

1672: );
1673:
1674: IF l_return_status = 'E'
1675: THEN
1676: FND_MSG_PUB.Get (
1677: p_msg_index => FND_MSG_PUB.G_LAST,
1678: p_encoded => FND_API.G_TRUE ,
1679: p_data => l_data,
1680: p_msg_index_out => l_index_out

Line 1677: p_msg_index => FND_MSG_PUB.G_LAST,

1673:
1674: IF l_return_status = 'E'
1675: THEN
1676: FND_MSG_PUB.Get (
1677: p_msg_index => FND_MSG_PUB.G_LAST,
1678: p_encoded => FND_API.G_TRUE ,
1679: p_data => l_data,
1680: p_msg_index_out => l_index_out
1681: );

Line 1683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1697: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1709: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1712: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1715: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1718: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1721: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1724: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1733: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1744: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1747: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1750: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1746: AS_UTILITY_PVT.Debug_Message(
1747: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1748: ' Group_Id: ' || l_group_id);
1749: AS_UTILITY_PVT.Debug_Message(
1750: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1751: ' Person_Id: ' || l_person_id);
1752: END IF;
1753: Insert_Access_Records(
1754: p_resource_id => l_resource_id,

Line 1772: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1783: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1786: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1789: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1785: AS_UTILITY_PVT.Debug_Message(
1786: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1787: ' Group_Id: ' || l_group_id);
1788: AS_UTILITY_PVT.Debug_Message(
1789: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1790: ' Person_Id: ' || l_person_id);
1791: END IF;
1792: Insert_Access_Records(
1793: p_resource_id => l_resource_id,

Line 1837: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1849: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1860: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1882: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1931: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1951: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 1958: FND_MSG_PUB.Count_And_Get

1954:
1955: -- Standard call to get message count and IF count is 1, get message info.
1956: IF x_return_status = 'W'
1957: THEN
1958: FND_MSG_PUB.Count_And_Get
1959: (
1960: p_encoded => FND_API.G_FALSE,
1961: p_count => x_msg_count,
1962: p_data => x_msg_data );

Line 1964: FND_MSG_PUB.Count_And_Get

1960: p_encoded => FND_API.G_FALSE,
1961: p_count => x_msg_count,
1962: p_data => x_msg_data );
1963: ELSE
1964: FND_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count,
1966: p_data => x_msg_data );
1967: END IF;
1968:

Line 1974: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 1984: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 2378: FND_MSG_PUB.initialize;

2374:
2375: -- Initialize message list IF p_init_msg_list is set to TRUE.
2376: IF FND_API.to_Boolean( p_init_msg_list )
2377: THEN
2378: FND_MSG_PUB.initialize;
2379: END IF;
2380:
2381: -- Debug Message
2382: IF (AS_DEBUG_LOW_ON) THEN

Line 2383: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2416: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2424: FND_MSG_PUB.Count_And_Get

2420: END IF;
2421:
2422: -- Standard call to get message count and IF count is 1,
2423: -- get message info.
2424: FND_MSG_PUB.Count_And_Get
2425: ( p_count => x_msg_count,
2426: p_data => x_msg_data );
2427:
2428: RETURN;

Line 2441: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2450: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2455: FND_MSG_PUB.Count_And_Get

2451: 'Lead Online TAP is disabled!');
2452: END IF;
2453: -- Standard call to get message count and IF count is 1,
2454: -- get message info.
2455: FND_MSG_PUB.Count_And_Get
2456: ( p_count => x_msg_count,
2457: p_data => x_msg_data );
2458:
2459: RETURN;

Line 2463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2470: -- ******************************************************************
2471:
2472: IF FND_GLOBAL.User_Id IS NULL
2473: THEN
2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2475: THEN
2476: AS_UTILITY_PVT.Set_Message(
2477: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2478: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 2477: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2473: THEN
2474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2475: THEN
2476: AS_UTILITY_PVT.Set_Message(
2477: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2478: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2479: p_token1 => 'PROFILE',
2480: p_token1_value => 'USER_ID');
2481: END IF;

Line 2506: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2508: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2510: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2519: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2528: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2560: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2637: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2650: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2652: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2654: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2656: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2658: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2660: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2662: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2664: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2666: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2668: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2670: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2672: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2674: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2676: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2678: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2682: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2684: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2686: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2688: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2690: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2692: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2723: FND_MSG_PUB.Get (

2719: );
2720:
2721: IF l_return_status = 'E'
2722: THEN
2723: FND_MSG_PUB.Get (
2724: p_msg_index => FND_MSG_PUB.G_LAST,
2725: p_encoded => FND_API.G_TRUE ,
2726: p_data => l_data,
2727: p_msg_index_out => l_index_out

Line 2724: p_msg_index => FND_MSG_PUB.G_LAST,

2720:
2721: IF l_return_status = 'E'
2722: THEN
2723: FND_MSG_PUB.Get (
2724: p_msg_index => FND_MSG_PUB.G_LAST,
2725: p_encoded => FND_API.G_TRUE ,
2726: p_data => l_data,
2727: p_msg_index_out => l_index_out
2728: );

Line 2730: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2741: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2743: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2745: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2747: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2758: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2770: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2773: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2776: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2779: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2782: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2794: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2805: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2808: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2811: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2807: AS_UTILITY_PVT.Debug_Message(
2808: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2809: ' Group_Id: ' || l_group_id);
2810: AS_UTILITY_PVT.Debug_Message(
2811: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2812: ' Person_Id: ' || l_person_id);
2813: END IF;
2814: Create_Access_Records(
2815: p_resource_id => l_resource_id,

Line 2834: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2845: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2848: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2851: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2847: AS_UTILITY_PVT.Debug_Message(
2848: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2849: ' Group_Id: ' || l_group_id);
2850: AS_UTILITY_PVT.Debug_Message(
2851: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2852: ' Person_Id: ' || l_person_id);
2853: END IF;
2854: Create_Access_Records(
2855: p_resource_id => l_resource_id,

Line 2901: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2936: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2945: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2977: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 2984: FND_MSG_PUB.Count_And_Get

2980:
2981: -- Standard call to get message count and IF count is 1, get message info.
2982: IF x_return_status = 'W'
2983: THEN
2984: FND_MSG_PUB.Count_And_Get
2985: (
2986: p_encoded => FND_API.G_FALSE,
2987: p_count => x_msg_count,
2988: p_data => x_msg_data );

Line 2990: FND_MSG_PUB.Count_And_Get

2986: p_encoded => FND_API.G_FALSE,
2987: p_count => x_msg_count,
2988: p_data => x_msg_data );
2989: ELSE
2990: FND_MSG_PUB.Count_And_Get
2991: ( p_count => x_msg_count,
2992: p_data => x_msg_data );
2993: END IF;
2994:

Line 3000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 3010: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

Line 3125: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3194: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3593: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3595: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3615: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3617: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3641: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3755: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3766: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3785: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3795: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3815: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3869: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3881: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3885: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3907: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3931: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3934: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 3942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4014: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4017: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4203: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4217: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4235: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4237: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

Line 4408: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4404:
4405: IF l_resource_id IS NULL
4406: THEN
4407: IF (AS_DEBUG_LOW_ON) THEN
4408: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4409: 'profile not set');
4410: END IF;
4411: -- Profile is not set. hence going against the logged in user
4412:

Line 4419: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4415: IF (C_get_current_resource%NOTFOUND)
4416: THEN
4417: IF (AS_DEBUG_LOW_ON) THEN
4418: AS_UTILITY_PVT.Debug_Message(
4419: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4420: 'No current resource found!');
4421: END IF;
4422: END IF;
4423: CLOSE C_get_current_resource;

Line 4429: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4425: IF l_resource_id IS NOT NULL
4426: THEN
4427: IF (AS_DEBUG_LOW_ON) THEN
4428: AS_UTILITY_PVT.Debug_Message(
4429: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4430: 'Users resource id is:' || l_resource_id);
4431: END IF;
4432:
4433: IF p_salesgroup_id = fnd_api.g_miss_num

Line 4447: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4443: FETCH c_get_person_id INTO l_person_id;
4444: CLOSE c_get_person_id;
4445: IF (AS_DEBUG_LOW_ON) THEN
4446: AS_UTILITY_PVT.Debug_Message(
4447: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4448: 'Users group id is:' || l_group_id);
4449: END IF;
4450:
4451: END IF; -- l_resource_id IS NOT NULL

Line 4455: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4451: END IF; -- l_resource_id IS NOT NULL
4452: ELSE -- profile resource id is not null
4453: -- Profile was set with some resource id
4454: IF (AS_DEBUG_LOW_ON) THEN
4455: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4456: 'Profile resource id:'|| l_resource_id);
4457: END IF;
4458: OPEN c_get_group_id (l_resource_id);
4459: FETCH c_get_group_id INTO l_group_id;

Line 4465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4461: OPEN c_get_person_id (l_resource_id);
4462: FETCH c_get_person_id INTO l_person_id;
4463: CLOSE c_get_person_id;
4464: IF (AS_DEBUG_LOW_ON) THEN
4465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4466: 'Profile group id:' || l_group_id);
4467: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4468: 'Profile person id:' || l_person_id);
4469: END IF;

Line 4467: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4463: CLOSE c_get_person_id;
4464: IF (AS_DEBUG_LOW_ON) THEN
4465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4466: 'Profile group id:' || l_group_id);
4467: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4468: 'Profile person id:' || l_person_id);
4469: END IF;
4470:
4471: END IF; -- l_resource_id IS NULL

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

4476: l_qualified_flag, l_freeze_flag, l_status_code;
4477: CLOSE c_sales_lead;
4478:
4479: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4480: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4481: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4482:
4483: -- Call API to create log entry
4484: AS_SALES_LEADS_LOG_PKG.Insert_Row(

Line 4614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4610: FETCH c_access_exist INTO l_access_exist_flag;
4611: CLOSE c_access_exist;
4612:
4613: IF (AS_DEBUG_LOW_ON) THEN
4614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4615: 'access exist?'|| l_access_exist_flag);
4616: END IF;
4617: IF l_reject_reason_code IS NOT NULL
4618: THEN

Line 4671: FND_MSG_PUB.Count_And_Get

4667: (sales_group_id IS NULL AND l_group_id IS NULL));
4668: END IF;
4669:
4670: -- Standard call to get message count and IF count is 1, get message info.
4671: FND_MSG_PUB.Count_And_Get
4672: ( p_count => x_msg_count,
4673: p_data => x_msg_data );
4674: END Set_Default_Lead_Owner;
4675:

Line 4812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4808: ELSE
4809: -- Customer return owner, update AS_SALES_LEADS_LOG and
4810: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4811: IF (AS_DEBUG_LOW_ON) THEN
4812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4813: 'res id in upd=' || l_Resource_Id);
4814: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4815: 'group id in upd='||l_group_id);
4816: END IF;

Line 4814: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4810: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4811: IF (AS_DEBUG_LOW_ON) THEN
4812: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4813: 'res id in upd=' || l_Resource_Id);
4814: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4815: 'group id in upd='||l_group_id);
4816: END IF;
4817:
4818: OPEN c_sales_lead(p_sales_lead_id);

Line 5097: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5093: l_lead_rank_score NUMBER;
5094: l_creation_date DATE;
5095: BEGIN
5096: IF (AS_DEBUG_LOW_ON) THEN
5097: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5098: 'Get_Partner_Lead_Owner');
5099: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5100: 'g_i_count=' || g_i_count);
5101: END IF;

Line 5099: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5095: BEGIN
5096: IF (AS_DEBUG_LOW_ON) THEN
5097: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5098: 'Get_Partner_Lead_Owner');
5099: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5100: 'g_i_count=' || g_i_count);
5101: END IF;
5102: l_found_flag := 'N';
5103: IF g_i_count > 0

Line 5118: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5114: END LOOP;
5115: END IF;
5116:
5117: IF (AS_DEBUG_LOW_ON) THEN
5118: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5119: 'Owner found?' || l_found_flag);
5120: END IF;
5121: IF l_found_flag = 'Y'
5122: THEN

Line 5130: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5126: -- no owner found, get owner from profile
5127: l_resource_id := fnd_profile.value('AS_DEFAULT_CM_FOR_LEAD');
5128:
5129: IF (AS_DEBUG_LOW_ON) THEN
5130: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5131: 'AS_DEFAULT_CM=' || l_resource_id);
5132: END IF;
5133: IF l_resource_id IS NULL
5134: THEN

Line 5136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

5132: END IF;
5133: IF l_resource_id IS NULL
5134: THEN
5135: IF (AS_DEBUG_ERROR_ON) THEN
5136: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
5137: 'AS_NO_DEFAULT_CM');
5138: END IF;
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;

Line 5152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5148: FETCH c_get_person_id INTO l_person_id;
5149: CLOSE c_get_person_id;
5150:
5151: IF (AS_DEBUG_LOW_ON) THEN
5152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5153: 'Owner sf_id=' || l_resource_id || ',g=' || l_group_id);
5154: END IF;
5155: OPEN c_sales_lead(p_sales_lead_id);
5156: FETCH c_sales_lead INTO l_customer_id, l_address_id,

Line 5388: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5384: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
5385: IF l_rs_id IS NULL
5386: THEN
5387: IF (AS_DEBUG_LOW_ON) THEN
5388: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5389: 'profile not set');
5390: END IF;
5391: -- Profile is not set. hence going against the logged in user
5392:

Line 5398: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5394: FETCH C_get_current_resource INTO l_rs_id;
5395: IF (C_get_current_resource%NOTFOUND)
5396: THEN
5397: IF (AS_DEBUG_LOW_ON) THEN
5398: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5399: 'No resource found for login user!');
5400: END IF;
5401: CLOSE C_get_current_resource;
5402: RETURN;

Line 5409: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5405:
5406: IF l_rs_id IS NOT NULL
5407: THEN
5408: IF (AS_DEBUG_LOW_ON) THEN
5409: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5410: 'User''s resource id is:' || l_rs_id);
5411: END IF;
5412: IF p_salesgroup_id = fnd_api.g_miss_num
5413: THEN

Line 5426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5422: OPEN c_get_person_id (l_rs_id);
5423: FETCH c_get_person_id INTO g_person_id_tbl(1);
5424: CLOSE c_get_person_id;
5425: IF (AS_DEBUG_LOW_ON) THEN
5426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5427: 'Users group id is:' || g_group_id_tbl(1));
5428: END IF;
5429: g_resource_id_tbl(1) := l_rs_id;
5430: g_resource_flag_tbl(1) := 'L';

Line 5435: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5431: END IF;
5432:
5433: ELSE -- profile resource id is not null
5434: IF (AS_DEBUG_LOW_ON) THEN
5435: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5436: 'Profile resource id :'|| l_rs_id);
5437: END IF;
5438: g_group_id_tbl(1) := NULL;
5439: OPEN c_get_group_id (l_rs_id);

Line 5446: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5442: OPEN c_get_person_id (l_rs_id);
5443: FETCH c_get_person_id INTO g_person_id_tbl(1);
5444: CLOSE c_get_person_id;
5445: IF (AS_DEBUG_LOW_ON) THEN
5446: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5447: 'Profile group id :' || g_group_id_tbl(1));
5448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5449: 'Profile person id :' || g_person_id_tbl(1));
5450: END IF;

Line 5448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5444: CLOSE c_get_person_id;
5445: IF (AS_DEBUG_LOW_ON) THEN
5446: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5447: 'Profile group id :' || g_group_id_tbl(1));
5448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5449: 'Profile person id :' || g_person_id_tbl(1));
5450: END IF;
5451: g_resource_id_tbl(1) := l_rs_id;
5452: g_resource_flag_tbl(1) := 'D';

Line 5461: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5457: THEN
5458: CLOSE C_get_current_resource;
5459: -- result := 'COMPLETE:ERROR';
5460: IF (AS_DEBUG_LOW_ON) THEN
5461: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5462: 'No resource found!');
5463: END IF;
5464: RETURN;
5465: END IF;

Line 5472: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5468: IF l_rs_id IS NOT NULL AND
5469: l_rs_id <> g_resource_id_tbl(1)
5470: THEN
5471: IF (AS_DEBUG_LOW_ON) THEN
5472: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5473: 'User''s resource id is:' || l_rs_id);
5474: END IF;
5475: IF p_salesgroup_id = fnd_api.g_miss_num
5476: THEN

Line 5489: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5485: OPEN c_get_person_id (l_rs_id);
5486: FETCH c_get_person_id INTO g_person_id_tbl(2);
5487: CLOSE c_get_person_id;
5488: IF (AS_DEBUG_LOW_ON) THEN
5489: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5490: 'Users group id is:' || g_group_id_tbl(2));
5491: END IF;
5492: g_resource_id_tbl(2) := l_rs_id;
5493: g_resource_flag_tbl(2) := 'L';

Line 5538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5534: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))
5535: ORDER BY ACC.ACCESS_ID;
5536: BEGIN
5537: IF (AS_DEBUG_LOW_ON) THEN
5538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5539: 'Get_Available_Resource: Start');
5540: END IF;
5541:
5542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5554: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5550:
5551: l_check_calendar :=
5552: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
5553: IF (AS_DEBUG_LOW_ON) THEN
5554: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5555: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
5556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5557: 'Check calendar?' || l_check_calendar);
5558: END IF;

Line 5556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5552: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
5553: IF (AS_DEBUG_LOW_ON) THEN
5554: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5555: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
5556: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5557: 'Check calendar?' || l_check_calendar);
5558: END IF;
5559:
5560: g_resource_id_tbl.delete;

Line 5570: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5566: WHILE l_index1 <= l_last
5567: LOOP
5568: IF (AS_DEBUG_LOW_ON) THEN
5569: AS_UTILITY_PVT.Debug_Message(
5570: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5571: 'Check resource ' || l_resource_id_tbl(l_index1));
5572: END IF;
5573: -- Check the calendar for resource availability
5574: -- Call Calendar API

Line 5599: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5595: END IF;
5596:
5597: IF (AS_DEBUG_LOW_ON) THEN
5598: AS_UTILITY_PVT.Debug_Message(
5599: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5600: 'l_shift_construct_id=' || l_shift_construct_id);
5601: END IF;
5602: IF l_shift_construct_id IS NOT NULL
5603: THEN

Line 5621: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5617: g_resource_flag_tbl := l_resource_flag_tbl;
5618: END IF; -- l_check_calendar = 'Y' AND l_last > 0
5619:
5620: IF (AS_DEBUG_LOW_ON) THEN
5621: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5622: 'g_resource_id_tbl.count=' || g_resource_id_tbl.count);
5623: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5624: 'Get_Available_Resource: End');
5625: END IF;

Line 5623: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5619:
5620: IF (AS_DEBUG_LOW_ON) THEN
5621: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5622: 'g_resource_id_tbl.count=' || g_resource_id_tbl.count);
5623: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5624: 'Get_Available_Resource: End');
5625: END IF;
5626:
5627: EXCEPTION

Line 5630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5626:
5627: EXCEPTION
5628: WHEN OTHERS THEN
5629: IF (AS_DEBUG_LOW_ON) THEN
5630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5631: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
5632: END IF;
5633: END Get_Available_Resource;
5634:

Line 5693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5689: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
5690: AND ACC.CREATED_BY_TAP_FLAG = 'Y';
5691: BEGIN
5692: IF (AS_DEBUG_LOW_ON) THEN
5693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5694: 'Get_Owner: Start');
5695: END IF;
5696:
5697: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5710: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5706: -- USER HOOK standard : customer pre-processing section - mandatory
5707: IF l_call_user_hook
5708: THEN
5709: IF (AS_DEBUG_LOW_ON) THEN
5710: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5711: 'Call user_hook is true');
5712: END IF;
5713: OPEN c_get_sales_lead(p_sales_lead_id);
5714: FETCH c_get_sales_lead INTO

Line 5786: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5782: l_sales_lead_rec.LEAD_RANK_IND,
5783: l_sales_lead_rec.CURRENT_REROUTES;
5784: CLOSE c_get_sales_lead;
5785: IF (AS_DEBUG_LOW_ON) THEN
5786: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5787: 'desc:' || l_sales_lead_rec.description);
5788: END IF;
5789:
5790: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(

Line 5820: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5816: THEN
5817: IF NOT l_call_user_hook
5818: THEN
5819: IF (AS_DEBUG_LOW_ON) THEN
5820: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5821: 'There''s no customer user hook');
5822: END IF;
5823: ELSE
5824: IF (AS_DEBUG_LOW_ON) THEN

Line 5825: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5821: 'There''s no customer user hook');
5822: END IF;
5823: ELSE
5824: IF (AS_DEBUG_LOW_ON) THEN
5825: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5826: 'User hook doesn''t return resource');
5827: END IF;
5828: END IF;
5829:

Line 5843: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5839: OPEN c_get_resource_avail(p_sales_lead_id);
5840: FETCH c_get_resource_avail INTO l_resource_avail_flag;
5841: CLOSE c_get_resource_avail;
5842: IF (AS_DEBUG_LOW_ON) THEN
5843: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5844: 'res avail?' || l_resource_avail_flag);
5845: END IF;
5846: x_return_status := 'W';
5847: IF l_resource_avail_flag = 'Y'

Line 5852: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

5848: THEN
5849: -- There are resources available, but they were previous lead
5850: -- owners.
5851: AS_UTILITY_PVT.Set_Message(
5852: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5853: p_msg_name => 'AS_WARN_DEF_RESOURCE_ID');
5854: ELSE
5855: AS_UTILITY_PVT.Set_Message(
5856: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 5856: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

5852: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5853: p_msg_name => 'AS_WARN_DEF_RESOURCE_ID');
5854: ELSE
5855: AS_UTILITY_PVT.Set_Message(
5856: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5857: p_msg_name => 'AS_WARN_USING_DEF_RESOURCE_ID');
5858: END IF;
5859: ELSIF g_resource_flag_tbl(1) = 'L'
5860: THEN

Line 5863: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

5859: ELSIF g_resource_flag_tbl(1) = 'L'
5860: THEN
5861: x_return_status := 'W';
5862: AS_UTILITY_PVT.Set_Message(
5863: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5864: p_msg_name => 'AS_WARN_USING_USER_RESOURCE_ID');
5865: END IF;
5866: END IF;
5867: IF (AS_DEBUG_LOW_ON) THEN

Line 5868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5864: p_msg_name => 'AS_WARN_USING_USER_RESOURCE_ID');
5865: END IF;
5866: END IF;
5867: IF (AS_DEBUG_LOW_ON) THEN
5868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5869: 'Set owner rs_id=' || l_resource_id);
5870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5871: ' group_id=' || l_group_id);
5872: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 5870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5866: END IF;
5867: IF (AS_DEBUG_LOW_ON) THEN
5868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5869: 'Set owner rs_id=' || l_resource_id);
5870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5871: ' group_id=' || l_group_id);
5872: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5873: ' person_id=' || l_person_id);
5874: END IF;

Line 5872: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5869: 'Set owner rs_id=' || l_resource_id);
5870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5871: ' group_id=' || l_group_id);
5872: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5873: ' person_id=' || l_person_id);
5874: END IF;
5875:
5876: x_resource_id := l_resource_id;

Line 5880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5876: x_resource_id := l_resource_id;
5877: x_group_id := l_group_id;
5878: x_person_id := l_person_id;
5879: IF (AS_DEBUG_LOW_ON) THEN
5880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5881: 'Get_Owner: End');
5882: END IF;
5883: -- Standard call to get message count and IF count is 1, get message info.
5884: FND_MSG_PUB.Count_And_Get

Line 5884: FND_MSG_PUB.Count_And_Get

5880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5881: 'Get_Owner: End');
5882: END IF;
5883: -- Standard call to get message count and IF count is 1, get message info.
5884: FND_MSG_PUB.Count_And_Get
5885: ( p_count => x_msg_count,
5886: p_data => x_msg_data );
5887: EXCEPTION
5888: WHEN OTHERS THEN

Line 5890: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5886: p_data => x_msg_data );
5887: EXCEPTION
5888: WHEN OTHERS THEN
5889: IF (AS_DEBUG_LOW_ON) THEN
5890: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5891: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
5892: END IF;
5893: END Get_Owner;
5894:

Line 5944: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5940: AND sl.status_code = sta.status_code
5941: AND sl.lead_rank_id = rk.rank_id(+);
5942: BEGIN
5943: IF (AS_DEBUG_LOW_ON) THEN
5944: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5945: 'Update_Sales_Leads: Start');
5946: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5947: 'res id in upd=' || p_Resource_Id);
5948: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 5946: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5942: BEGIN
5943: IF (AS_DEBUG_LOW_ON) THEN
5944: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5945: 'Update_Sales_Leads: Start');
5946: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5947: 'res id in upd=' || p_Resource_Id);
5948: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5949: 'group id in upd='||p_group_id);
5950: END IF;

Line 5948: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5944: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5945: 'Update_Sales_Leads: Start');
5946: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5947: 'res id in upd=' || p_Resource_Id);
5948: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5949: 'group id in upd='||p_group_id);
5950: END IF;
5951:
5952: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6139: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6135: FROM SYS.DUAL;
6136: END IF; -- l_access_exist_flag IS NOT NULL
6137:
6138: IF (AS_DEBUG_LOW_ON) THEN
6139: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6140: 'Update_Sales_Leads: End');
6141: END IF;
6142:
6143: EXCEPTION

Line 6185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6181: ELSE
6182: l_assign_manual_flag :=
6183: nvl(FND_PROFILE.Value('AS_LEAD_ASSIGN_MANUAL'),'N');
6184: IF (AS_DEBUG_LOW_ON) THEN
6185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6186: 'manual assign profile=' || l_assign_manual_flag);
6187: END IF;
6188:
6189: IF l_assign_manual_flag = 'N'

Line 6196: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6192: THEN
6193: -- Debug Message
6194: IF (AS_DEBUG_LOW_ON) THEN
6195: AS_UTILITY_PVT.Debug_Message(
6196: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6197: 'Oracle internal, custom user hook');
6198: END IF;
6199:
6200: Oracle_Internal_CUHK(

Line 6269: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6265: -- only owner will be left for this transaction.
6266: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N'
6267: THEN
6268: IF (AS_DEBUG_LOW_ON) THEN
6269: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6270: 'Lead Online TAP is disabled!');
6271: END IF;
6272: Remove_Redundant_Accesses(p_sales_lead_id, p_request_id);
6273: END IF;

Line 6277: FND_MSG_PUB.Count_And_Get

6273: END IF;
6274: Process_Access_Record(p_sales_lead_id, p_request_id);
6275:
6276: -- Standard call to get message count and IF count is 1, get message info.
6277: FND_MSG_PUB.Count_And_Get
6278: ( p_count => x_msg_count,
6279: p_data => x_msg_data );
6280: END Find_Lead_Owner;
6281: