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.3.12010000.2 2008/12/11 07:36:19 vpalle ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERR_SERVICE_PUB

2: /* $Header: jtfptsvb.pls 120.3.12010000.2 2008/12/11 07:36:19 vpalle 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 : ' || 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 475: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',

471:
472: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
473: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
475: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
476: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
477: END IF;
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;

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

480:
481: -- debug message
482: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.string(FND_LOG.LEVEL_EVENT,
484: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
485: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
486: END IF;
487:
488: JTY_ASSIGN_REALTIME_PUB.process_winners (

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

501:
502: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
503: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
504: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
505: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
506: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
507: END IF;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;

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

510:
511: -- debug message
512: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
513: FND_LOG.string(FND_LOG.LEVEL_EVENT,
514: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
515: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
516: END IF;
517:
518: /*

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

545:
546: -- debug message
547: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
549: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
550: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
551: END IF;
552:
553: EXCEPTION

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

546: -- debug message
547: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
549: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
550: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
551: END IF;
552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN

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

553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
557: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
558: substr(x_msg_data, 1, 4000));
559: END IF;
560:
561: WHEN OTHERS THEN

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

563: x_msg_data := SQLCODE || ' : ' || SQLERRM;
564: x_msg_count := 1;
565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
567: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
568: substr(x_msg_data, 1, 4000));
569: END IF;
570:
571: End Get_WinningTerrMembers;

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

631: BEGIN
632: -- debug message
633: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
635: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
636: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
637: END IF;
638:
639: -- Standard call to check for call compatibility.

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

632: -- debug message
633: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
635: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
636: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
637: END IF;
638:
639: -- Standard call to check for call compatibility.
640: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

658:
659: -- debug message
660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
662: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
663: 'Country : ' || p_TerrSrvTask_Rec.COUNTRY || ' City : ' || p_TerrSrvTask_Rec.CITY ||
664: ' Postal Code : ' || p_TerrSrvTask_Rec.POSTAL_CODE || ' State : ' || p_TerrSrvTask_Rec.STATE ||
665: ' Area Code : ' || p_TerrSrvTask_Rec.AREA_CODE || ' County : ' || p_TerrSrvTask_Rec.COUNTY ||
666: ' Company Name Range : ' || p_TerrSrvTask_Rec.COMP_NAME_RANGE || ' Province : ' || p_TerrSrvTask_Rec.PROVINCE ||

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

1015:
1016: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1017: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1019: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1020: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1021: END IF;
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;

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

1024:
1025: -- debug message
1026: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1028: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1029: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
1030: END IF;
1031:
1032: JTY_ASSIGN_REALTIME_PUB.process_winners (

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

1045:
1046: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1049: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1050: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1051: END IF;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;

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

1054:
1055: -- debug message
1056: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1058: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1059: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1060: END IF;
1061:
1062: /*

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

1089:
1090: -- debug message
1091: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1092: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1093: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1094: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1095: END IF;
1096:
1097: EXCEPTION

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

1090: -- debug message
1091: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1092: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1093: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1094: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1095: END IF;
1096:
1097: EXCEPTION
1098: WHEN FND_API.G_EXC_ERROR THEN

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

1098: WHEN FND_API.G_EXC_ERROR THEN
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1102: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1103: substr(x_msg_data, 1, 4000));
1104: END IF;
1105:
1106: WHEN OTHERS THEN

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

1108: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1109: x_msg_count := 1;
1110: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1111: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1112: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
1113: substr(x_msg_data, 1, 4000));
1114: END IF;
1115:
1116: End Get_WinningTerrMembers;

Line 1118: END JTF_TERR_SERVICE_PUB;

1114: END IF;
1115:
1116: End Get_WinningTerrMembers;
1117:
1118: END JTF_TERR_SERVICE_PUB;