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 AS_UTILITY_PVT

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 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 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 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 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 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 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 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 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 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 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 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 608: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

604:
605: EXCEPTION
606:
607: WHEN FND_API.G_EXC_ERROR THEN
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

Line 613: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
617: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 625: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
629: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 632: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

628: ,X_MSG_DATA => X_MSG_DATA
629: ,X_RETURN_STATUS => X_RETURN_STATUS);
630:
631: WHEN OTHERS THEN
632: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_MODULE => l_module
634: ,P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

632: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_MODULE => l_module
634: ,P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
637: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
638: ,P_ROLLBACK_FLAG => 'N'
639: ,X_MSG_COUNT => X_MSG_COUNT
640: ,X_MSG_DATA => X_MSG_DATA

Line 637: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

633: P_MODULE => l_module
634: ,P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
637: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
638: ,P_ROLLBACK_FLAG => 'N'
639: ,X_MSG_COUNT => X_MSG_COUNT
640: ,X_MSG_DATA => X_MSG_DATA
641: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 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 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 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 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 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 887: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

883:
884: EXCEPTION
885:
886: WHEN FND_API.G_EXC_ERROR THEN
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

Line 892: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
896: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 899: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

895: ,X_MSG_DATA => X_MSG_DATA
896: ,X_RETURN_STATUS => X_RETURN_STATUS);
897:
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 904: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
908: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 911: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

907: ,X_MSG_DATA => X_MSG_DATA
908: ,X_RETURN_STATUS => X_RETURN_STATUS);
909:
910: WHEN OTHERS THEN
911: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
912: P_MODULE => l_module
913: ,P_API_NAME => L_API_NAME
914: ,P_PKG_NAME => G_PKG_NAME
915: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 915: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

911: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
912: P_MODULE => l_module
913: ,P_API_NAME => L_API_NAME
914: ,P_PKG_NAME => G_PKG_NAME
915: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
916: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
917: ,P_ROLLBACK_FLAG => 'N'
918: ,X_MSG_COUNT => X_MSG_COUNT
919: ,X_MSG_DATA => X_MSG_DATA

Line 916: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

912: P_MODULE => l_module
913: ,P_API_NAME => L_API_NAME
914: ,P_PKG_NAME => G_PKG_NAME
915: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
916: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
917: ,P_ROLLBACK_FLAG => 'N'
918: ,X_MSG_COUNT => X_MSG_COUNT
919: ,X_MSG_DATA => X_MSG_DATA
920: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 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 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 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 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 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 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 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 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 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 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 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 1152: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1148:
1149: EXCEPTION
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1157: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
1161: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1164: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1160: ,X_MSG_DATA => X_MSG_DATA
1161: ,X_RETURN_STATUS => X_RETURN_STATUS);
1162:
1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 1169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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
1173: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1176: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1172: ,X_MSG_DATA => X_MSG_DATA
1173: ,X_RETURN_STATUS => X_RETURN_STATUS);
1174:
1175: WHEN OTHERS THEN
1176: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1177: P_MODULE => l_module
1178: ,P_API_NAME => L_API_NAME
1179: ,P_PKG_NAME => G_PKG_NAME
1180: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1180: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1176: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1177: P_MODULE => l_module
1178: ,P_API_NAME => L_API_NAME
1179: ,P_PKG_NAME => G_PKG_NAME
1180: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1181: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1182: ,P_ROLLBACK_FLAG => 'N'
1183: ,X_MSG_COUNT => X_MSG_COUNT
1184: ,X_MSG_DATA => X_MSG_DATA

Line 1181: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1177: P_MODULE => l_module
1178: ,P_API_NAME => L_API_NAME
1179: ,P_PKG_NAME => G_PKG_NAME
1180: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1181: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1182: ,P_ROLLBACK_FLAG => 'N'
1183: ,X_MSG_COUNT => X_MSG_COUNT
1184: ,X_MSG_DATA => X_MSG_DATA
1185: ,X_RETURN_STATUS => X_RETURN_STATUS);