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_ORG_MANAGER_PVT dependencies on FND_MSG_PUB

Line 442: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

438: l_where_cl Varchar2(1000);
439: l_cur_get_salesgroup Number;
440: l_ignore Number;
441: l_curr_row Number := 0;
442: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
443: l_module CONSTANT VARCHAR2(255) := 'as.plsql.sompv.Get_Sales_groups';
444:
445: BEGIN
446:

Line 460: FND_MSG_PUB.initialize;

456:
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_Boolean( p_init_msg_list ) THEN
460: FND_MSG_PUB.initialize;
461: END IF;
462:
463: -- Debug Message
464: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 464: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

460: FND_MSG_PUB.initialize;
461: END IF;
462:
463: -- Debug Message
464: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
465: THEN
466: IF l_debug THEN
467: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups - BEGIN');
468: END IF;

Line 467: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups - BEGIN');

463: -- Debug Message
464: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
465: THEN
466: IF l_debug THEN
467: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups - BEGIN');
468: END IF;
469: END IF;
470:
471: -- Initialize API return status to success

Line 479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

475: -- API body
476:
477: Begin
478:
479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
480: IF l_debug THEN
481: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Open Cursor');
482: END IF;
483: END IF;

Line 481: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Open Cursor');

477: Begin
478:
479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
480: IF l_debug THEN
481: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Open Cursor');
482: END IF;
483: END IF;
484:
485: l_cur_get_salesgroup := DBMS_SQL.open_cursor;

Line 487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

483: END IF;
484:
485: l_cur_get_salesgroup := DBMS_SQL.open_cursor;
486:
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
488: IF l_debug THEN
489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Select');
490: END IF;
491: END IF;

Line 489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Select');

485: l_cur_get_salesgroup := DBMS_SQL.open_cursor;
486:
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
488: IF l_debug THEN
489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Select');
490: END IF;
491: END IF;
492:
493: l_select_cl := get_sales_group_gen_select;

Line 495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

491: END IF;
492:
493: l_select_cl := get_sales_group_gen_select;
494:
495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: IF l_debug THEN
497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Where');
498: END IF;
499: END IF;

Line 497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Where');

493: l_select_cl := get_sales_group_gen_select;
494:
495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: IF l_debug THEN
497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Generate Where');
498: END IF;
499: END IF;
500:
501: l_where_cl := get_sales_group_gen_where(p_sales_group_rec);

Line 503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

499: END IF;
500:
501: l_where_cl := get_sales_group_gen_where(p_sales_group_rec);
502:
503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
504: IF l_debug THEN
505: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Parse SQL');
506: END IF;
507: END IF;

Line 505: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Parse SQL');

501: l_where_cl := get_sales_group_gen_where(p_sales_group_rec);
502:
503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
504: IF l_debug THEN
505: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Parse SQL');
506: END IF;
507: END IF;
508:
509: DBMS_SQL.parse(l_cur_get_salesgroup,

Line 512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

508:
509: DBMS_SQL.parse(l_cur_get_salesgroup,
510: l_select_cl || l_where_cl, DBMS_SQL.native);
511:
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
513: IF l_debug THEN
514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Define Columns');
515: END IF;
516: END IF;

Line 514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Define Columns');

510: l_select_cl || l_where_cl, DBMS_SQL.native);
511:
512: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
513: IF l_debug THEN
514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Define Columns');
515: END IF;
516: END IF;
517:
518: get_sales_group_define_columns(l_cur_get_salesgroup);

Line 520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

516: END IF;
517:
518: get_sales_group_define_columns(l_cur_get_salesgroup);
519:
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
521: IF l_debug THEN
522: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Bind Variables');
523: END IF;
524: END IF;

Line 522: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Bind Variables');

518: get_sales_group_define_columns(l_cur_get_salesgroup);
519:
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
521: IF l_debug THEN
522: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Bind Variables');
523: END IF;
524: END IF;
525:
526: get_sales_group_bind_variables(l_cur_get_salesgroup, p_sales_group_rec);

Line 528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

524: END IF;
525:
526: get_sales_group_bind_variables(l_cur_get_salesgroup, p_sales_group_rec);
527:
528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
529: IF l_debug THEN
530: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Execute SQL');
531: END IF;
532: END IF;

Line 530: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Execute SQL');

526: get_sales_group_bind_variables(l_cur_get_salesgroup, p_sales_group_rec);
527:
528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
529: IF l_debug THEN
530: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Execute SQL');
531: END IF;
532: END IF;
533:
534: l_ignore := DBMS_SQL.Execute(l_cur_get_salesgroup);

Line 536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

532: END IF;
533:
534: l_ignore := DBMS_SQL.Execute(l_cur_get_salesgroup);
535:
536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: IF l_debug THEN
538: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Column Values');
539: END IF;
540: END IF;

Line 538: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Column Values');

534: l_ignore := DBMS_SQL.Execute(l_cur_get_salesgroup);
535:
536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: IF l_debug THEN
538: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Column Values');
539: END IF;
540: END IF;
541:
542: Loop

Line 552: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

548: Exit;
549: End if;
550: End Loop;
551:
552: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
553: IF l_debug THEN
554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Close cursor');
555: END IF;
556: END IF;

Line 554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Close cursor');

550: End Loop;
551:
552: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
553: IF l_debug THEN
554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Close cursor');
555: END IF;
556: END IF;
557:
558: DBMS_SQL.Close_Cursor(l_cur_get_salesgroup);

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

561: EXCEPTION
562:
563: WHEN NO_DATA_FOUND THEN
564:
565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
566: THEN
567: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesgroup'); -- MMSG
568: --FND_MSG_PUB.ADD;
569: IF l_debug THEN

Line 568: --FND_MSG_PUB.ADD;

564:
565: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
566: THEN
567: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesgroup'); -- MMSG
568: --FND_MSG_PUB.ADD;
569: IF l_debug THEN
570: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT: Cannot find sales group');
571: END IF;
572: END IF;

Line 570: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT: Cannot find sales group');

566: THEN
567: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesgroup'); -- MMSG
568: --FND_MSG_PUB.ADD;
569: IF l_debug THEN
570: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT: Cannot find sales group');
571: END IF;
572: END IF;
573:
574: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 576: FND_MSG_PUB.Count_And_Get

572: END IF;
573:
574: x_return_status := FND_API.G_RET_STS_SUCCESS ;
575:
576: FND_MSG_PUB.Count_And_Get
577: ( p_count => x_msg_count,
578: p_data => x_msg_data
579: );
580: return;

Line 589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

585:
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: -- Debug Message
589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
590: THEN
591: IF l_debug THEN
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups End');
593: END IF;

Line 592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups End');

588: -- Debug Message
589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
590: THEN
591: IF l_debug THEN
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups End');
593: END IF;
594: --FND_MESSAGE.Set_Name('AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser End');
595: --FND_MSG_PUB.Add;
596: END IF;

Line 595: --FND_MSG_PUB.Add;

591: IF l_debug THEN
592: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT.Get_Sales_groups End');
593: END IF;
594: --FND_MESSAGE.Set_Name('AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser End');
595: --FND_MSG_PUB.Add;
596: END IF;
597:
598: -- Standard call to get message count and if count is 1, get message info.
599: FND_MSG_PUB.Count_And_Get

Line 599: FND_MSG_PUB.Count_And_Get

595: --FND_MSG_PUB.Add;
596: END IF;
597:
598: -- Standard call to get message count and if count is 1, get message info.
599: FND_MSG_PUB.Count_And_Get
600: ( p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603:

Line 612: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

608: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
609: P_MODULE => l_module
610: ,P_API_NAME => L_API_NAME
611: ,P_PKG_NAME => G_PKG_NAME
612: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
613: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
614: ,P_ROLLBACK_FLAG => 'N'
615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA

Line 624: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_MODULE => l_module
622: ,P_API_NAME => L_API_NAME
623: ,P_PKG_NAME => G_PKG_NAME
624: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
625: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
626: ,P_ROLLBACK_FLAG => 'N'
627: ,X_MSG_COUNT => X_MSG_COUNT
628: ,X_MSG_DATA => X_MSG_DATA

Line 719: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

715: check_salesforce_id NUMBER;
716:
717: l_api_name CONSTANT VARCHAR2(30) := 'Get_CurrentUser';
718: l_api_version_number CONSTANT NUMBER := 2.0;
719: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
720: l_module CONSTANT VARCHAR2(255) := 'as.plsql.sompv.Get_CurrentUser';
721:
722: BEGIN
723:

Line 736: FND_MSG_PUB.initialize;

732:
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Debug Message
740: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 740: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Debug Message
740: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
741: THEN
742: IF l_debug THEN
743: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser - BEGIN');
744: END IF;

Line 743: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser - BEGIN');

739: -- Debug Message
740: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
741: THEN
742: IF l_debug THEN
743: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser - BEGIN');
744: END IF;
745: END IF;
746:
747: -- Initialize API return status to success

Line 757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

753: Begin
754:
755: -- re-initializing this variable due to weird bug. this valus is lost when the package is called
756: IF (FND_GLOBAL.User_Id < 0) THEN
757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
758: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
759: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
760: FND_MSG_PUB.ADD;
761: END IF;

Line 760: FND_MSG_PUB.ADD;

756: IF (FND_GLOBAL.User_Id < 0) THEN
757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
758: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
759: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
760: FND_MSG_PUB.ADD;
761: END IF;
762:
763: open C_GetIdentity_SFID(p_salesforce_id);
764: Fetch C_GetIdentity_SFID Into x_sales_member_rec.salesforce_id,

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

772: x_sales_member_rec.partner_contact_id;
773: Close C_GetIdentity_SFID;
774: -- RAISE FND_API.G_EXC_ERROR;
775: Else
776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
777: IF l_debug THEN
778: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Using FndUser to find identity');
779: END IF;
780: END IF;

Line 778: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Using FndUser to find identity');

774: -- RAISE FND_API.G_EXC_ERROR;
775: Else
776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
777: IF l_debug THEN
778: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Using FndUser to find identity');
779: END IF;
780: END IF;
781:
782: Open C_GetIdentity_FndUser(FND_GLOBAL.User_Id);

Line 786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

782: Open C_GetIdentity_FndUser(FND_GLOBAL.User_Id);
783:
784: If (C_GetIdentity_FndUser%ROWCOUNT > 1) Then
785:
786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
787: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Found duplicated salesrep'); -- MMSG
788: --FND_MSG_PUB.ADD;
789: IF l_debug THEN
790: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Found duplicated salesrep');

Line 788: --FND_MSG_PUB.ADD;

784: If (C_GetIdentity_FndUser%ROWCOUNT > 1) Then
785:
786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
787: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Found duplicated salesrep'); -- MMSG
788: --FND_MSG_PUB.ADD;
789: IF l_debug THEN
790: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Found duplicated salesrep');
791: END IF;
792: END IF;

Line 790: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Found duplicated salesrep');

786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
787: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Found duplicated salesrep'); -- MMSG
788: --FND_MSG_PUB.ADD;
789: IF l_debug THEN
790: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Found duplicated salesrep');
791: END IF;
792: END IF;
793: End if;
794: Fetch C_GetIdentity_FndUser Into x_sales_member_rec.salesforce_id,

Line 809: FND_MSG_PUB.ADD;

805: -- raise error if salesforce_id is null
806: If (x_sales_member_rec.salesforce_id is null OR x_sales_member_rec.salesforce_id = FND_API.G_MISS_NUM) Then
807: FND_MESSAGE.Set_Name('AS', 'AS_INVALID_USER_ID');
808: FND_MESSAGE.Set_Token('VALUE', FND_GLOBAL.USER_ID, FALSE);
809: FND_MSG_PUB.ADD;
810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
811: IF l_debug THEN
812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Cannot identify user by checking user_id at JTF resource');
813: END IF;

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

806: If (x_sales_member_rec.salesforce_id is null OR x_sales_member_rec.salesforce_id = FND_API.G_MISS_NUM) Then
807: FND_MESSAGE.Set_Name('AS', 'AS_INVALID_USER_ID');
808: FND_MESSAGE.Set_Token('VALUE', FND_GLOBAL.USER_ID, FALSE);
809: FND_MSG_PUB.ADD;
810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
811: IF l_debug THEN
812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Cannot identify user by checking user_id at JTF resource');
813: END IF;
814: END IF;

Line 812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Cannot identify user by checking user_id at JTF resource');

808: FND_MESSAGE.Set_Token('VALUE', FND_GLOBAL.USER_ID, FALSE);
809: FND_MSG_PUB.ADD;
810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
811: IF l_debug THEN
812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Cannot identify user by checking user_id at JTF resource');
813: END IF;
814: END IF;
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: FND_MSG_PUB.Count_And_Get

Line 816: FND_MSG_PUB.Count_And_Get

812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT - Cannot identify user by checking user_id at JTF resource');
813: END IF;
814: END IF;
815: x_return_status := FND_API.G_RET_STS_ERROR ;
816: FND_MSG_PUB.Count_And_Get
817: ( p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820: return;

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

839: EXCEPTION
840:
841: WHEN NO_DATA_FOUND THEN
842:
843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
844: THEN
845: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesrep'); -- MMSG
846: --FND_MSG_PUB.ADD;
847: IF l_debug THEN

Line 846: --FND_MSG_PUB.ADD;

842:
843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
844: THEN
845: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesrep'); -- MMSG
846: --FND_MSG_PUB.ADD;
847: IF l_debug THEN
848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT: Cannot identify user');
849: END IF;
850: END IF;

Line 848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT: Cannot identify user');

844: THEN
845: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesrep'); -- MMSG
846: --FND_MSG_PUB.ADD;
847: IF l_debug THEN
848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT: Cannot identify user');
849: END IF;
850: END IF;
851:
852: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 854: FND_MSG_PUB.Count_And_Get

850: END IF;
851:
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853:
854: FND_MSG_PUB.Count_And_Get
855: ( p_count => x_msg_count,
856: p_data => x_msg_data
857: );
858: return;

Line 868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

864:
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- Debug Message
868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
869: THEN
870: IF l_debug THEN
871: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser End');
872: END IF;

Line 871: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser End');

867: -- Debug Message
868: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
869: THEN
870: IF l_debug THEN
871: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser End');
872: END IF;
873: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PVT.Get_CurrentUser End');
874: --FND_MSG_PUB.Add;
875: END IF;

Line 874: --FND_MSG_PUB.Add;

870: IF l_debug THEN
871: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_CurrentUser End');
872: END IF;
873: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PVT.Get_CurrentUser End');
874: --FND_MSG_PUB.Add;
875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info.
878: FND_MSG_PUB.Count_And_Get

Line 878: FND_MSG_PUB.Count_And_Get

874: --FND_MSG_PUB.Add;
875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info.
878: FND_MSG_PUB.Count_And_Get
879: ( p_count => x_msg_count,
880: p_data => x_msg_data
881: );
882:

Line 891: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

887: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
888: P_MODULE => l_module
889: ,P_API_NAME => L_API_NAME
890: ,P_PKG_NAME => G_PKG_NAME
891: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
892: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
893: ,P_ROLLBACK_FLAG => 'N'
894: ,X_MSG_COUNT => X_MSG_COUNT
895: ,X_MSG_DATA => X_MSG_DATA

Line 903: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

899: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_MODULE => l_module
901: ,P_API_NAME => L_API_NAME
902: ,P_PKG_NAME => G_PKG_NAME
903: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
904: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
905: ,P_ROLLBACK_FLAG => 'N'
906: ,X_MSG_COUNT => X_MSG_COUNT
907: ,X_MSG_DATA => X_MSG_DATA

Line 967: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

963: l_where_cl Varchar2(1000);
964: l_cur_get_salesmember Number;
965: l_ignore Number;
966: l_curr_row Number := 0;
967: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
968: l_module CONSTANT VARCHAR2(255) := 'as.plsql.sompv.Get_Sales_members';
969:
970: BEGIN
971:

Line 985: FND_MSG_PUB.initialize;

981:
982:
983: -- Initialize message list if p_init_msg_list is set to TRUE.
984: IF FND_API.to_Boolean( p_init_msg_list ) THEN
985: FND_MSG_PUB.initialize;
986: END IF;
987:
988: -- Debug Message
989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

985: FND_MSG_PUB.initialize;
986: END IF;
987:
988: -- Debug Message
989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
990: THEN
991: IF l_debug THEN
992: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members - BEGIN');
993: END IF;

Line 992: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members - BEGIN');

988: -- Debug Message
989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
990: THEN
991: IF l_debug THEN
992: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members - BEGIN');
993: END IF;
994: END IF;
995:
996: -- Initialize API return status to success

Line 1004: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1000: -- API body
1001:
1002: Begin
1003:
1004: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1005: IF l_debug THEN
1006: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Open Cursor');
1007: END IF;
1008: END IF;

Line 1006: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Open Cursor');

1002: Begin
1003:
1004: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1005: IF l_debug THEN
1006: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Open Cursor');
1007: END IF;
1008: END IF;
1009:
1010: l_cur_get_salesmember := DBMS_SQL.open_cursor;

Line 1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1008: END IF;
1009:
1010: l_cur_get_salesmember := DBMS_SQL.open_cursor;
1011:
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: IF l_debug THEN
1014: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Select');
1015: END IF;
1016: END IF;

Line 1014: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Select');

1010: l_cur_get_salesmember := DBMS_SQL.open_cursor;
1011:
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: IF l_debug THEN
1014: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Select');
1015: END IF;
1016: END IF;
1017:
1018: open C_GetGroupExist(p_sales_member_rec.salesforce_id);

Line 1027: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1023: l_select_cl := get_salesmem_gen_select_w_grp;
1024: END IF;
1025: close C_GetGroupExist;
1026:
1027: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1028: IF l_debug THEN
1029: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Where');
1030: END IF;
1031: END IF;

Line 1029: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Where');

1025: close C_GetGroupExist;
1026:
1027: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1028: IF l_debug THEN
1029: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Generate Where');
1030: END IF;
1031: END IF;
1032:
1033: open C_GetGroupExist(p_sales_member_rec.salesforce_id);

Line 1042: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1038: l_where_cl := get_salesmem_gen_where_w_grp(p_sales_member_rec);
1039: END IF;
1040: close C_GetGroupExist;
1041:
1042: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1043: IF l_debug THEN
1044: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Parse SQL');
1045: END IF;
1046: END IF;

Line 1044: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Parse SQL');

1040: close C_GetGroupExist;
1041:
1042: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1043: IF l_debug THEN
1044: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_ORG_MANAGER_PVT - Parse SQL');
1045: END IF;
1046: END IF;
1047:
1048:

Line 1053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1049: DBMS_SQL.parse(l_cur_get_salesmember,
1050: l_select_cl || l_where_cl, DBMS_SQL.native);
1051:
1052:
1053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1054: IF l_debug THEN
1055: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Define Columns');
1056: END IF;
1057: END IF;

Line 1055: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Define Columns');

1051:
1052:
1053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1054: IF l_debug THEN
1055: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Define Columns');
1056: END IF;
1057: END IF;
1058:
1059: get_salesmem_define_cols(l_cur_get_salesmember);

Line 1061: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1057: END IF;
1058:
1059: get_salesmem_define_cols(l_cur_get_salesmember);
1060:
1061: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1062: IF l_debug THEN
1063: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Bind Variables');
1064: END IF;
1065: END IF;

Line 1063: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Bind Variables');

1059: get_salesmem_define_cols(l_cur_get_salesmember);
1060:
1061: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1062: IF l_debug THEN
1063: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Bind Variables');
1064: END IF;
1065: END IF;
1066:
1067: get_salesmem_bind_vars(l_cur_get_salesmember, p_sales_member_rec);

Line 1069: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1065: END IF;
1066:
1067: get_salesmem_bind_vars(l_cur_get_salesmember, p_sales_member_rec);
1068:
1069: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: IF l_debug THEN
1071: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Execute SQL');
1072: END IF;
1073: END IF;

Line 1071: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Execute SQL');

1067: get_salesmem_bind_vars(l_cur_get_salesmember, p_sales_member_rec);
1068:
1069: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: IF l_debug THEN
1071: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Execute SQL');
1072: END IF;
1073: END IF;
1074:
1075: l_ignore := DBMS_SQL.Execute(l_cur_get_salesmember);

Line 1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1073: END IF;
1074:
1075: l_ignore := DBMS_SQL.Execute(l_cur_get_salesmember);
1076:
1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1078: IF l_debug THEN
1079: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Column Values');
1080: END IF;
1081: END IF;

Line 1079: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Column Values');

1075: l_ignore := DBMS_SQL.Execute(l_cur_get_salesmember);
1076:
1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1078: IF l_debug THEN
1079: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Column Values');
1080: END IF;
1081: END IF;
1082:
1083:

Line 1097: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1093: Exit;
1094: End if;
1095: End Loop;
1096:
1097: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1098: IF l_debug THEN
1099: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Close cursor');
1100: END IF;
1101: END IF;

Line 1099: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Close cursor');

1095: End Loop;
1096:
1097: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1098: IF l_debug THEN
1099: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_ORG_MANAGER_PVT - Close cursor');
1100: END IF;
1101: END IF;
1102:
1103: DBMS_SQL.Close_Cursor(l_cur_get_salesmember);

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

1105: EXCEPTION
1106:
1107: WHEN NO_DATA_FOUND THEN
1108:
1109: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1110: THEN
1111: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesrep'); -- MMSG
1112: --FND_MSG_PUB.ADD;
1113: IF l_debug THEN

Line 1112: --FND_MSG_PUB.ADD;

1108:
1109: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1110: THEN
1111: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesrep'); -- MMSG
1112: --FND_MSG_PUB.ADD;
1113: IF l_debug THEN
1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PVT: Cannot find user');
1115: END IF;
1116: END IF;

Line 1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PVT: Cannot find user');

1110: THEN
1111: --FND_MESSAGE.Set_Name('AS', 'Pvt Pipeline API: Cannot find salesrep'); -- MMSG
1112: --FND_MSG_PUB.ADD;
1113: IF l_debug THEN
1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'AS_SALES_MEMBER_PVT: Cannot find user');
1115: END IF;
1116: END IF;
1117:
1118: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1120: FND_MSG_PUB.Count_And_Get

1116: END IF;
1117:
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119:
1120: FND_MSG_PUB.Count_And_Get
1121: ( p_count => x_msg_count,
1122: p_data => x_msg_data
1123: );
1124:

Line 1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1129: -- End of API body.
1130: --
1131:
1132: -- Debug Message
1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1134: THEN
1135: IF l_debug THEN
1136: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members End');
1137: END IF;

Line 1136: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members End');

1132: -- Debug Message
1133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1134: THEN
1135: IF l_debug THEN
1136: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members End');
1137: END IF;
1138: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PVT.Get_CurrentUser End');
1139: --FND_MSG_PUB.Add;
1140: END IF;

Line 1139: --FND_MSG_PUB.Add;

1135: IF l_debug THEN
1136: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_SALES_MEMBER_PVT.Get_Sales_Members End');
1137: END IF;
1138: --FND_MESSAGE.Set_Name('AS_SALES_MEMBER_PVT.Get_CurrentUser End');
1139: --FND_MSG_PUB.Add;
1140: END IF;
1141:
1142: -- Standard call to get message count and if count is 1, get message info.
1143: FND_MSG_PUB.Count_And_Get

Line 1143: FND_MSG_PUB.Count_And_Get

1139: --FND_MSG_PUB.Add;
1140: END IF;
1141:
1142: -- Standard call to get message count and if count is 1, get message info.
1143: FND_MSG_PUB.Count_And_Get
1144: ( p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147:

Line 1156: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1152: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1153: P_MODULE => l_module
1154: ,P_API_NAME => L_API_NAME
1155: ,P_PKG_NAME => G_PKG_NAME
1156: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1157: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1158: ,P_ROLLBACK_FLAG => 'N'
1159: ,X_MSG_COUNT => X_MSG_COUNT
1160: ,X_MSG_DATA => X_MSG_DATA

Line 1168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1164: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1165: P_MODULE => l_module
1166: ,P_API_NAME => L_API_NAME
1167: ,P_PKG_NAME => G_PKG_NAME
1168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1170: ,P_ROLLBACK_FLAG => 'N'
1171: ,X_MSG_COUNT => X_MSG_COUNT
1172: ,X_MSG_DATA => X_MSG_DATA