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_SALES_ORG_MANAGER_PVT

Line 1: PACKAGE BODY AS_SALES_ORG_MANAGER_PVT as

1: PACKAGE BODY AS_SALES_ORG_MANAGER_PVT as
2: /* $Header: asxvsomb.pls 120.1 2005/06/23 01:05:40 appldev ship $ */
3:
4: --
5: -- NAME

Line 6: -- AS_SALES_ORG_MANAGER_PVT

2: /* $Header: asxvsomb.pls 120.1 2005/06/23 01:05:40 appldev ship $ */
3:
4: --
5: -- NAME
6: -- AS_SALES_ORG_MANAGER_PVT
7: --
8: -- HISTORY
9: -- 6/19/98 ALHUNG CREATED
10: --

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_ORG_MANAGER_PVT';

9: -- 6/19/98 ALHUNG CREATED
10: --
11: --
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_ORG_MANAGER_PVT';
14: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvsomb.pls';
15:
16:
17: -- Following are private procedures and functions used by Get_Sales_Groups

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 594: --FND_MESSAGE.Set_Name('AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser End');

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;
597:
598: -- Standard call to get message count and if count is 1, get message info.

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 1352: END AS_SALES_ORG_MANAGER_PVT;

1348: CLOSE l_admin_role_cursor;
1349: RETURN l_member_role;
1350: END Get_Member_Role;
1351:
1352: END AS_SALES_ORG_MANAGER_PVT;