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

Line 91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

87: -- API Body Definitions
88: -- ***************************************************
89: PROCEDURE get_winners
90: ( p_api_version_number IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_use_type IN VARCHAR2 := 'RESOURCE',
93: p_source_id IN NUMBER,
94: p_trans_id IN NUMBER,
95: p_trans_rec IN bulk_trans_rec_type,

Line 96: p_resource_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

92: p_use_type IN VARCHAR2 := 'RESOURCE',
93: p_source_id IN NUMBER,
94: p_trans_id IN NUMBER,
95: p_trans_rec IN bulk_trans_rec_type,
96: p_resource_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2,

Line 97: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR,

93: p_source_id IN NUMBER,
94: p_trans_id IN NUMBER,
95: p_trans_rec IN bulk_trans_rec_type,
96: p_resource_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,

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

94: p_trans_id IN NUMBER,
95: p_trans_rec IN bulk_trans_rec_type,
96: p_resource_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,

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

95: p_trans_rec IN bulk_trans_rec_type,
96: p_resource_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
97: p_role IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
99: p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: x_winners_rec OUT NOCOPY bulk_winners_rec_type

Line 131: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

127: 'Start of the procedure jtf_terr_assign_pub.get_winners');
128: END IF;
129:
130: -- Standard call to check for call compatibility.
131: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
132: p_api_version_number,
133: l_api_name,
134: G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
132: p_api_version_number,
133: l_api_name,
134: G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: -- Initialize message list if p_init_msg_list is set to TRUE.
139: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 139: IF FND_API.to_Boolean( p_init_msg_list ) THEN

135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: -- Initialize message list if p_init_msg_list is set to TRUE.
139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: ------------------

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142:
143: ------------------
144: -- API body
145: ------------------
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147: l_sysdate := SYSDATE;
148: l_count1 := 0;
149: l_num_of_terr := 0;
150: l_counter := 0;

Line 151: IF (p_role = FND_API.G_MISS_CHAR) THEN

147: l_sysdate := SYSDATE;
148: l_count1 := 0;
149: l_num_of_terr := 0;
150: l_counter := 0;
151: IF (p_role = FND_API.G_MISS_CHAR) THEN
152: l_role := null;
153: ELSE
154: l_role := p_role;
155: END IF;

Line 156: IF (p_resource_type = FND_API.G_MISS_CHAR) THEN

152: l_role := null;
153: ELSE
154: l_role := p_role;
155: END IF;
156: IF (p_resource_type = FND_API.G_MISS_CHAR) THEN
157: l_resource_type := null;
158: ELSE
159: l_resource_type := p_resource_type;
160: END IF;

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

814: ,x_return_status => x_return_status
815: ,x_msg_count => x_msg_count
816: ,x_msg_data => x_msg_data);
817:
818: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
819: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
820: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
821: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
822: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');

Line 824: RAISE FND_API.G_EXC_ERROR;

820: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
821: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
822: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
823: END IF;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826:
827: -- debug message
828: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

842: ,x_msg_count => x_msg_count
843: ,x_msg_data => x_msg_data
844: ,x_winners_rec => lx_winners_rec);
845:
846: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
847: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
849: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
850: 'JTY_ASSIGN_REALTIME_PUB.process_winners has failed');

Line 852: RAISE FND_API.G_EXC_ERROR;

848: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
849: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
850: 'JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
851: END IF;
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: -- debug message
856: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 907: WHEN FND_API.G_EXC_ERROR THEN

903: 'End of the procedure jtf_terr_assign_pub.get_winners');
904: END IF;
905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
910: 'jtf.plsql.jtf_terr_assign_pub.get_winners.g_exc_error',
911: substr(x_msg_data, 1, 4000));

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

911: substr(x_msg_data, 1, 4000));
912: END IF;
913:
914: WHEN OTHERS THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916: x_msg_data := SQLCODE || ' : ' || SQLERRM;
917: x_msg_count := 1;
918: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,