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 FND_API

Line 71: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false

67: -- parameters :
68: --
69: -- IN:
70: -- p_api_version_number IN number required
71: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
72: -- p_commit IN varchar2 optional --default = fnd_api.g_false
73: -- p_Org_Id IN number required
74: -- p_TerrServReq_Rec IN JTF_Serv_Req_rec_type
75: -- p_Resource_Type IN varchar2

Line 72: -- p_commit IN varchar2 optional --default = fnd_api.g_false

68: --
69: -- IN:
70: -- p_api_version_number IN number required
71: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
72: -- p_commit IN varchar2 optional --default = fnd_api.g_false
73: -- p_Org_Id IN number required
74: -- p_TerrServReq_Rec IN JTF_Serv_Req_rec_type
75: -- p_Resource_Type IN varchar2
76: -- p_Role IN varchar2

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

90: --
91: -- end of comments
92: procedure Get_WinningTerrMembers
93: ( p_api_version_number IN number,
94: p_init_msg_list IN varchar2 := fnd_api.g_false,
95: p_TerrServReq_Rec IN JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type,
96: p_Resource_Type IN varchar2,
97: p_Role IN varchar2,
98: p_plan_start_date IN DATE DEFAULT NULL,

Line 122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )

Line 131: IF FND_API.to_Boolean( p_init_msg_list )

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )
132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: END IF;
135:
136: --
137: -- API body
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,

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

468: ,x_return_status => x_return_status
469: ,x_msg_count => x_msg_count
470: ,x_msg_data => x_msg_data);
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');

Line 478: RAISE FND_API.G_EXC_ERROR;

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;
480:
481: -- debug message
482: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

498: ,x_msg_count => x_msg_count
499: ,x_msg_data => x_msg_data
500: ,x_winners_rec => lx_winners_rec);
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');

Line 508: RAISE FND_API.G_EXC_ERROR;

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;
510:
511: -- debug message
512: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 554: WHEN FND_API.G_EXC_ERROR THEN

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
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));

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

558: substr(x_msg_data, 1, 4000));
559: END IF;
560:
561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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,

Line 585: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false

581: -- parameters :
582: --
583: -- IN:
584: -- p_api_version_number IN number required
585: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
586: -- p_commit IN varchar2 optional --default = fnd_api.g_false
587: -- p_Org_Id IN number required
588: -- p_TerrSrvTask_Rec IN JTF_srv_Task_rec_type
589: -- p_Resource_Type IN varchar2

Line 586: -- p_commit IN varchar2 optional --default = fnd_api.g_false

582: --
583: -- IN:
584: -- p_api_version_number IN number required
585: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
586: -- p_commit IN varchar2 optional --default = fnd_api.g_false
587: -- p_Org_Id IN number required
588: -- p_TerrSrvTask_Rec IN JTF_srv_Task_rec_type
589: -- p_Resource_Type IN varchar2
590: -- p_Role IN varchar2

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

609: --
610: -- end of comments
611: procedure Get_WinningTerrMembers
612: ( p_api_version_number IN number,
613: p_init_msg_list IN varchar2 := fnd_api.g_false,
614: p_TerrSrvTask_Rec IN JTF_TERRITORY_PUB.JTF_Srv_Task_rec_type,
615: p_Resource_Type IN varchar2,
616: p_Role IN varchar2,
617: p_plan_start_date IN DATE DEFAULT NULL,

Line 640: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
641: p_api_version_number,
642: l_api_name,
643: G_PKG_NAME)
644: THEN

Line 645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

641: p_api_version_number,
642: l_api_name,
643: G_PKG_NAME)
644: THEN
645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
646: END IF;
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list )

Line 649: IF FND_API.to_Boolean( p_init_msg_list )

645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
646: END IF;
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list )
650: THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653:

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653:
654: --
655: -- API body
656: --
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,

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

1012: ,x_return_status => x_return_status
1013: ,x_msg_count => x_msg_count
1014: ,x_msg_data => x_msg_data);
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');

Line 1022: RAISE FND_API.G_EXC_ERROR;

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;
1024:
1025: -- debug message
1026: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1042: ,x_msg_count => x_msg_count
1043: ,x_msg_data => x_msg_data
1044: ,x_winners_rec => lx_winners_rec);
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');

Line 1052: RAISE FND_API.G_EXC_ERROR;

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;
1054:
1055: -- debug message
1056: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1098: WHEN FND_API.G_EXC_ERROR THEN

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
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',

Line 1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1095: END IF;
1096:
1097: EXCEPTION
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));

Line 1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1103: substr(x_msg_data, 1, 4000));
1104: END IF;
1105:
1106: WHEN OTHERS THEN
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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,