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_SALES_PUB dependencies on FND_API

Line 88: p_init_msg_list IN varchar2 := fnd_api.g_false,

84: --
85: -- end of comments
86: procedure Get_WinningTerrMembers
87: ( p_api_version_number IN number,
88: p_init_msg_list IN varchar2 := fnd_api.g_false,
89: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
90: p_Resource_Type IN varchar2,
91: p_Role IN varchar2,
92: x_return_status OUT NOCOPY varchar2,

Line 96: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,

92: x_return_status OUT NOCOPY varchar2,
93: x_msg_count OUT NOCOPY number,
94: X_msg_data OUT NOCOPY varchar2,
95: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
96: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_num_winners IN NUMBER := FND_API.G_MISS_NUM
98: )
99: AS
100: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerrMembers_Acct';

Line 97: p_num_winners IN NUMBER := FND_API.G_MISS_NUM

93: x_msg_count OUT NOCOPY number,
94: X_msg_data OUT NOCOPY varchar2,
95: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE,
96: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_num_winners IN NUMBER := FND_API.G_MISS_NUM
98: )
99: AS
100: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerrMembers_Acct';
101: l_api_version_number CONSTANT NUMBER := 1.0;

Line 111: WHEN FND_API.G_EXC_ERROR THEN

107:
108: BEGIN
109: null;
110: EXCEPTION
111: WHEN FND_API.G_EXC_ERROR THEN
112: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
114: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',
115: substr(x_msg_data, 1, 4000));

Line 119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

115: substr(x_msg_data, 1, 4000));
116: END IF;
117:
118: WHEN OTHERS THEN
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: x_msg_data := SQLCODE || ' : ' || SQLERRM;
121: x_msg_count := 1;
122: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
123: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 157: p_init_msg_list IN varchar2 := fnd_api.g_false,

153: --
154: -- end of comments
155: procedure Get_WinningTerrMembers
156: ( p_api_version_number IN number,
157: p_init_msg_list IN varchar2 := fnd_api.g_false,
158: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_BULK_rec_type,
159: p_Resource_Type IN varchar2,
160: p_Role IN varchar2,
161: x_return_status OUT NOCOPY varchar2,

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176:
177: null;
178:
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
182: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
183: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',
184: substr(x_msg_data, 1, 4000));

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

184: substr(x_msg_data, 1, 4000));
185: END IF;
186:
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: x_msg_data := SQLCODE || ' : ' || SQLERRM;
190: x_msg_count := 1;
191: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 227: p_init_msg_list IN varchar2 := fnd_api.g_false,

223: --
224: -- end of comments
225: procedure Get_WinningTerrMembers
226: ( p_api_version_number IN number,
227: p_init_msg_list IN varchar2 := fnd_api.g_false,
228: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
229: p_Resource_Type IN varchar2,
230: p_Role IN varchar2,
231: x_return_status OUT NOCOPY varchar2,

Line 255: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

251: 'Start of the procedure jtf_terr_sales_pub.get_winningterrmembers');
252: END IF;
253:
254: -- Standard call to check for call compatibility.
255: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
256: p_api_version_number,
257: l_api_name,
258: G_PKG_NAME)
259: THEN

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: p_api_version_number,
257: l_api_name,
258: G_PKG_NAME)
259: THEN
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262:
263: -- Initialize message list if p_init_msg_list is set to TRUE.
264: IF FND_API.to_Boolean( p_init_msg_list )

Line 264: IF FND_API.to_Boolean( p_init_msg_list )

260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262:
263: -- Initialize message list if p_init_msg_list is set to TRUE.
264: IF FND_API.to_Boolean( p_init_msg_list )
265: THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268:
269: --
270: -- API body
271: --
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: l_sysdate := SYSDATE;
274:
275: FOR i IN p_TerrLead_Rec.sales_lead_id.FIRST .. p_TerrLead_Rec.sales_lead_id.LAST LOOP
276: l_trans_rec.trans_object_id1 := jtf_terr_number_list(p_TerrLead_Rec.sales_lead_id(i));

Line 285: p_init_msg_list => FND_API.G_FALSE,

281: l_trans_rec.txn_date := jtf_terr_date_list(null);
282:
283: JTY_ASSIGN_REALTIME_PUB.get_winners(
284: p_api_version_number => 1.0,
285: p_init_msg_list => FND_API.G_FALSE,
286: p_source_id => -1001,
287: p_trans_id => -1003,
288: p_mode => 'REAL TIME:RESOURCE',
289: p_param_passing_mechanism => 'PBR',

Line 301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

297: x_msg_data => x_msg_data,
298: x_winners_rec => lx_winners_rec
299: );
300:
301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
302: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
304: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.get_winners',
305: 'API JTY_ASSIGN_REALTIME_PUB.get_winners has failed');

Line 307: RAISE FND_API.G_EXC_ERROR;

303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
304: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.get_winners',
305: 'API JTY_ASSIGN_REALTIME_PUB.get_winners has failed');
306: END IF;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309: END LOOP;
310:
311: -- debug message

Line 372: WHEN FND_API.G_EXC_ERROR THEN

368: 'End of the procedure jtf_terr_sales_pub.get_winningterrmembers');
369: END IF;
370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
375: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',
376: substr(x_msg_data, 1, 4000));

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

376: substr(x_msg_data, 1, 4000));
377: END IF;
378:
379: WHEN OTHERS THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: x_msg_data := SQLCODE || ' : ' || SQLERRM;
382: x_msg_count := 1;
383: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 431: p_init_msg_list IN varchar2 := fnd_api.g_false,

427: --
428: -- end of comments
429: procedure Get_WinningTerrMembers
430: ( p_api_version_number IN number,
431: p_init_msg_list IN varchar2 := fnd_api.g_false,
432: p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type,
433: p_Resource_Type IN varchar2,
434: p_Role IN varchar2,
435: x_return_status OUT NOCOPY varchar2,

Line 540: p_init_msg_list IN varchar2 := fnd_api.g_false,

536: --
537: -- end of comments
538: procedure Get_WinningTerritories
539: ( p_api_version_number IN number,
540: p_init_msg_list IN varchar2 := fnd_api.g_false,
541: x_return_status OUT NOCOPY varchar2,
542: x_msg_count OUT NOCOPY number,
543: X_msg_data OUT NOCOPY varchar2,
544: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type

Line 627: p_init_msg_list IN varchar2 := fnd_api.g_false,

623: --
624: -- end of comments
625: procedure Get_WinningTerritories
626: ( p_api_version_number IN number,
627: p_init_msg_list IN varchar2 := fnd_api.g_false,
628: x_return_status OUT NOCOPY varchar2,
629: x_msg_count OUT NOCOPY number,
630: X_msg_data OUT NOCOPY varchar2,
631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,

Line 633: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,

629: x_msg_count OUT NOCOPY number,
630: X_msg_data OUT NOCOPY varchar2,
631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
632: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
633: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
634: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
635: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR
636: )
637: AS

Line 634: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,

630: X_msg_data OUT NOCOPY varchar2,
631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
632: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
633: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
634: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
635: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR
636: )
637: AS
638: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerritories_Acct';

Line 635: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR

631: p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
632: x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
633: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
634: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
635: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR
636: )
637: AS
638: l_api_name CONSTANT VARCHAR2(30) := 'Get_WinningTerritories_Acct';
639: l_api_version_number CONSTANT NUMBER := 1.0;

Line 669: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

665: lp_Acc_Rec JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type;
666:
667: BEGIN
668: -- Standard call to check for call compatibility.
669: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
670: p_api_version_number,
671: l_api_name,
672: G_PKG_NAME)
673: THEN

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670: p_api_version_number,
671: l_api_name,
672: G_PKG_NAME)
673: THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: -- Initialize message list if p_init_msg_list is set to TRUE.
678: IF FND_API.to_Boolean( p_init_msg_list )

Line 678: IF FND_API.to_Boolean( p_init_msg_list )

674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676:
677: -- Initialize message list if p_init_msg_list is set to TRUE.
678: IF FND_API.to_Boolean( p_init_msg_list )
679: THEN
680: FND_MSG_PUB.initialize;
681: END IF;
682:

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: FND_MSG_PUB.Add;
688: END IF;
689:
690: -- Initialize API return status to success
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692:
693: --Reset the global variables
694: l_RetCode := JTF_TERRITORY_GLOBAL_PUB.Reset;
695:

Line 771: WHEN FND_API.G_EXC_ERROR THEN

767:
768:
769: EXCEPTION
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773:
774: FND_MSG_PUB.Count_And_Get
775: ( p_count => x_msg_count,

Line 772: x_return_status := FND_API.G_RET_STS_ERROR ;

768:
769: EXCEPTION
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773:
774: FND_MSG_PUB.Count_And_Get
775: ( p_count => x_msg_count,
776: p_data => x_msg_data

Line 780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

776: p_data => x_msg_data
777: );
778:
779:
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
782:
783: FND_MSG_PUB.Count_And_Get
784: ( p_count => x_msg_count,

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

777: );
778:
779:
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
782:
783: FND_MSG_PUB.Count_And_Get
784: ( p_count => x_msg_count,
785: p_data => x_msg_data

Line 790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

786: );
787:
788:
789: WHEN OTHERS THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791:
792: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
793: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_GEN_TERR_PACKAGE');
794: FND_MESSAGE.Set_Token('JTF', 'JTF_TERR_1001_ACCOUNT_DYN');

Line 838: p_init_msg_list IN varchar2 := fnd_api.g_false,

834: --
835: -- end of comments
836: procedure Get_WinningTerrMembers
837: ( p_api_version_number IN number,
838: p_init_msg_list IN varchar2 := fnd_api.g_false,
839: p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_rec_type,
840: p_Resource_Type IN varchar2,
841: p_Role IN varchar2,
842: x_return_status OUT NOCOPY varchar2,

Line 969: p_init_msg_list IN varchar2 := fnd_api.g_false,

965: --
966: -- end of comments
967: procedure Get_WinningTerrMembers
968: ( p_api_version_number IN number,
969: p_init_msg_list IN varchar2 := fnd_api.g_false,
970: p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_rec_type,
971: p_Resource_Type IN varchar2,
972: p_Role IN varchar2,
973: x_return_status OUT NOCOPY varchar2,