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

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

32: -- JTF_TERR_ALL to JTF_TERR
33: -- End of Comments
34: procedure Set_Winners_tbl
35: ( p_api_version_number IN number,
36: p_init_msg_list IN varchar2 := fnd_api.g_false,
37: p_party_id IN number ,
38: p_party_site_id IN number ,
39: p_asof_date IN date,
40: p_source_id IN number,

Line 84: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

80: 'Start of the procedure JTF_TERR_NAMEACC_PUB.Set_Winners_tbl');
81: END IF;
82: FND_MSG_PUB.initialize;
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
85: p_api_version_number,
86: l_api_name,
87: G_PKG_NAME)
88: THEN

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: p_api_version_number,
86: l_api_name,
87: G_PKG_NAME)
88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean( p_init_msg_list )
93: THEN

Line 92: IF FND_API.to_Boolean( p_init_msg_list )

88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean( p_init_msg_list )
93: THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96: -- Debug Message

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: FND_MESSAGE.Set_Name('JTF', G_PKG_NAME || '_START');
100: FND_MSG_PUB.Add;
101: END IF;
102: -- API body
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: lx_return_status := FND_API.G_RET_STS_SUCCESS;
105: lx_msg_data := null;
106:
107: -- Code for party name here...

Line 104: lx_return_status := FND_API.G_RET_STS_SUCCESS;

100: FND_MSG_PUB.Add;
101: END IF;
102: -- API body
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: lx_return_status := FND_API.G_RET_STS_SUCCESS;
105: lx_msg_data := null;
106:
107: -- Code for party name here...
108: if p_party_id is not null

Line 149: P_init_msg_list => FND_API.G_FALSE,

145: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in RealTime Mode');
146: END IF;
147: JTY_ASSIGN_REALTIME_PUB.get_winners(
148: P_api_version_number => 1.0,
149: P_init_msg_list => FND_API.G_FALSE,
150: P_source_id => -1001,
151: P_trans_id => -1002,
152: P_mode => 'REAL TIME:LOOKUP',
153: P_param_passing_mechanism => 'PBR',

Line 171: P_init_msg_list => FND_API.G_FALSE,

167: 'Calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners in Date EFfective Mode');
168: END IF;
169: JTY_ASSIGN_REALTIME_PUB.get_winners(
170: P_api_version_number => 1.0,
171: P_init_msg_list => FND_API.G_FALSE,
172: P_source_id => -1001,
173: P_trans_id => -1002,
174: P_mode => 'DATE EFFECTIVE:LOOKUP',
175: P_param_passing_mechanism => 'PBR',

Line 186: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

182: X_msg_count => lx_msg_count,
183: X_msg_data => lx_msg_data,
184: X_winners_rec => lx_winners_rec);
185: END IF;
186: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
187: -- debug message
188: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',

Line 193: RAISE FND_API.G_EXC_ERROR;

189: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
190: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',
191: 'JTY_ASSIGN_REALTIME_PUB.get_winners API has failed');
192: END IF;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
197: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.get_winners',

Line 208: p_resource_type => FND_API.G_MISS_CHAR,

204: p_use_type => 'LOOKUP',
205: p_source_id => -1001, -- -1001 Oracle Sales
206: p_trans_id => -1002, -- -1002 Account
207: p_trans_rec => lp_trans_Rec,
208: p_resource_type => FND_API.G_MISS_CHAR,
209: p_role => FND_API.G_MISS_CHAR,
210: p_top_level_terr_id => FND_API.G_MISS_NUM,
211: p_num_winners => FND_API.G_MISS_NUM,
212: x_return_status => lx_return_status,

Line 209: p_role => FND_API.G_MISS_CHAR,

205: p_source_id => -1001, -- -1001 Oracle Sales
206: p_trans_id => -1002, -- -1002 Account
207: p_trans_rec => lp_trans_Rec,
208: p_resource_type => FND_API.G_MISS_CHAR,
209: p_role => FND_API.G_MISS_CHAR,
210: p_top_level_terr_id => FND_API.G_MISS_NUM,
211: p_num_winners => FND_API.G_MISS_NUM,
212: x_return_status => lx_return_status,
213: x_msg_count => lx_msg_count,

Line 210: p_top_level_terr_id => FND_API.G_MISS_NUM,

206: p_trans_id => -1002, -- -1002 Account
207: p_trans_rec => lp_trans_Rec,
208: p_resource_type => FND_API.G_MISS_CHAR,
209: p_role => FND_API.G_MISS_CHAR,
210: p_top_level_terr_id => FND_API.G_MISS_NUM,
211: p_num_winners => FND_API.G_MISS_NUM,
212: x_return_status => lx_return_status,
213: x_msg_count => lx_msg_count,
214: x_msg_data => lx_msg_data,

Line 211: p_num_winners => FND_API.G_MISS_NUM,

207: p_trans_rec => lp_trans_Rec,
208: p_resource_type => FND_API.G_MISS_CHAR,
209: p_role => FND_API.G_MISS_CHAR,
210: p_top_level_terr_id => FND_API.G_MISS_NUM,
211: p_num_winners => FND_API.G_MISS_NUM,
212: x_return_status => lx_return_status,
213: x_msg_count => lx_msg_count,
214: x_msg_data => lx_msg_data,
215: x_winners_rec => lx_winners_rec

Line 325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

321: END IF;
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN NULL;
324: WHEN OTHERS THEN
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
326:
327: IF ( lx_msg_data is null )
328: THEN
329: x_msg_data := SQLCODE || ' : ' || SQLERRM;