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.JTF_TERR_SERVICE_PUB dependencies on JTF_TERR_SERVICE_PUB

Line 1: Package Body JTF_TERR_SERVICE_PUB AS

1: Package Body JTF_TERR_SERVICE_PUB AS
2: /* $Header: jtfptsvb.pls 120.8 2010/07/19 05:36:27 sseshaiy ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERR_SERVICE_PUB

2: /* $Header: jtfptsvb.pls 120.8 2010/07/19 05:36:27 sseshaiy ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERR_SERVICE_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force core territory manager public api's.
10: -- This package is a public API for getting winning territories

Line 56: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_SERVICE_PUB';

52: --
53: -- ***************************************************
54: -- GLOBAL VARIABLES
55: -- ***************************************************
56: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_SERVICE_PUB';
57: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptsvb.pls';
58:
59: -- Start of Comments
60: -- ***************************************************

Line 117: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',

113:
114: -- debug message
115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
117: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
118: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
119: END IF;
120:
121: -- Standard call to check for call compatibility.

Line 118: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');

114: -- debug message
115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
117: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
118: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
119: END IF;
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 143: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',

139:
140: -- debug message
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
143: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
144: 'Country : ' || p_TerrServReq_Rec.COUNTRY || ' City : ' || upper(p_TerrServReq_Rec.CITY) ||
145: ' Postal Code : ' || p_TerrServReq_Rec.POSTAL_CODE || ' State : ' || p_TerrServReq_Rec.STATE ||
146: ' Area Code : ' || p_TerrServReq_Rec.AREA_CODE || ' County : ' || p_TerrServReq_Rec.COUNTY ||
147: ' Company Name Range : ' || p_TerrServReq_Rec.COMP_NAME_RANGE || ' Province : ' || p_TerrServReq_Rec.PROVINCE ||

Line 501: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',

497:
498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
499: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
501: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
502: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
503: END IF;
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;

Line 510: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',

506:
507: -- debug message
508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.string(FND_LOG.LEVEL_EVENT,
510: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
511: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
512: END IF;
513:
514: JTY_ASSIGN_REALTIME_PUB.process_winners (

Line 531: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',

527:
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
532: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
533: END IF;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

Line 540: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',

536:
537: -- debug message
538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FND_LOG.string(FND_LOG.LEVEL_EVENT,
540: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
541: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
542: END IF;
543:
544: /*

Line 575: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',

571:
572: -- debug message
573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
575: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
576: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
577: END IF;
578:
579: EXCEPTION

Line 576: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');

572: -- debug message
573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
575: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
576: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
577: END IF;
578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN

Line 583: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',

579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN
581: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
583: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
584: substr(x_msg_data, 1, 4000));
585: END IF;
586:
587: WHEN OTHERS THEN

Line 593: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',

589: x_msg_data := SQLCODE || ' : ' || SQLERRM;
590: x_msg_count := 1;
591: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
593: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
594: substr(x_msg_data, 1, 4000));
595: END IF;
596:
597: End Get_WinningTerrMembers;

Line 661: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',

657: BEGIN
658: -- debug message
659: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
660: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
661: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
662: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
663: END IF;
664:
665: -- Standard call to check for call compatibility.

Line 662: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');

658: -- debug message
659: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
660: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
661: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
662: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
663: END IF;
664:
665: -- Standard call to check for call compatibility.
666: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 688: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',

684:
685: -- debug message
686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
688: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
689: 'Country : ' || p_TerrSrvTask_Rec.COUNTRY || ' City : ' || upper(p_TerrSrvTask_Rec.CITY) ||
690: ' Postal Code : ' || p_TerrSrvTask_Rec.POSTAL_CODE || ' State : ' || p_TerrSrvTask_Rec.STATE ||
691: ' Area Code : ' || p_TerrSrvTask_Rec.AREA_CODE || ' County : ' || p_TerrSrvTask_Rec.COUNTY ||
692: ' Company Name Range : ' || p_TerrSrvTask_Rec.COMP_NAME_RANGE || ' Province : ' || p_TerrSrvTask_Rec.PROVINCE ||

Line 1070: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',

1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1070: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1071: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1072: END IF;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1079: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',

1075:
1076: -- debug message
1077: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1079: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1080: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
1081: END IF;
1082:
1083: JTY_ASSIGN_REALTIME_PUB.process_winners (

Line 1100: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',

1096:
1097: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1098: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1099: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1100: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1101: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1102: END IF;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;

Line 1109: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',

1105:
1106: -- debug message
1107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1109: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1110: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1111: END IF;
1112:
1113: /*

Line 1144: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',

1140:
1141: -- debug message
1142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1144: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1145: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1146: END IF;
1147:
1148: EXCEPTION

Line 1145: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');

1141: -- debug message
1142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1144: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1145: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN

Line 1153: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',

1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1154: substr(x_msg_data, 1, 4000));
1155: END IF;
1156:
1157: WHEN OTHERS THEN

Line 1163: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',

1159: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1160: x_msg_count := 1;
1161: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1163: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
1164: substr(x_msg_data, 1, 4000));
1165: END IF;
1166:
1167: End Get_WinningTerrMembers;

Line 1169: END JTF_TERR_SERVICE_PUB;

1165: END IF;
1166:
1167: End Get_WinningTerrMembers;
1168:
1169: END JTF_TERR_SERVICE_PUB;