DBA Data[Home] [Help]

APPS.JTF_TERR_TASK_PUB dependencies on FND_API

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

57: -- parameters :
58: --
59: -- IN:
60: -- p_api_version_number IN number required
61: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
62: -- p_commit IN varchar2 optional --default = fnd_api.g_false
63: -- p_Org_Id IN number required
64: -- p_TerrTask_Rec IN JTF_ServiceReqst_rec_type
65: --

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

58: --
59: -- IN:
60: -- p_api_version_number IN number required
61: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
62: -- p_commit IN varchar2 optional --default = fnd_api.g_false
63: -- p_Org_Id IN number required
64: -- p_TerrTask_Rec IN JTF_ServiceReqst_rec_type
65: --
66: -- out:

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

82: --
83: -- end of comments
84: procedure Get_WinningTerrMembers
85: ( p_api_version_number IN number,
86: p_init_msg_list IN varchar2 := fnd_api.g_false,
87: p_TerrTask_Rec IN JTF_TERRITORY_PUB.JTF_Task_rec_type,
88: p_Resource_Type IN varchar2,
89: p_Role IN varchar2,
90: x_return_status OUT NOCOPY varchar2,

Line 114: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

110: 'Start of the procedure jtf_terr_task_pub.get_winningterrmembers');
111: END IF;
112:
113: -- Standard call to check for call compatibility.
114: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
115: p_api_version_number,
116: l_api_name,
117: G_PKG_NAME)
118: THEN

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

115: p_api_version_number,
116: l_api_name,
117: G_PKG_NAME)
118: THEN
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121:
122: -- Initialize message list if p_init_msg_list is set to TRUE.
123: IF FND_API.to_Boolean( p_init_msg_list )

Line 123: IF FND_API.to_Boolean( p_init_msg_list )

119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121:
122: -- Initialize message list if p_init_msg_list is set to TRUE.
123: IF FND_API.to_Boolean( p_init_msg_list )
124: THEN
125: FND_MSG_PUB.initialize;
126: END IF;
127:

Line 131: x_return_status := FND_API.G_RET_STS_SUCCESS;

127:
128: ------------------
129: -- API body
130: ------------------
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133: -- debug message
134: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

273: ,x_return_status => x_return_status
274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data);
276:
277: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
278: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
280: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_match',
281: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');

Line 283: RAISE FND_API.G_EXC_ERROR;

279: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
280: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_match',
281: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
282: END IF;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: -- debug message
287: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

301: ,x_msg_count => x_msg_count
302: ,x_msg_data => x_msg_data
303: ,x_winners_rec => lx_winners_rec);
304:
305: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
306: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
308: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_winners',
309: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');

Line 311: RAISE FND_API.G_EXC_ERROR;

307: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
308: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_winners',
309: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
310: END IF;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: -- debug message
315: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 356: WHEN FND_API.G_EXC_ERROR THEN

352: 'End of the procedure jtf_terr_task_pub.get_winningterrmembers');
353: END IF;
354:
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
359: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.g_exc_error',
360: substr(x_msg_data, 1, 4000));

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

360: substr(x_msg_data, 1, 4000));
361: END IF;
362:
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: x_msg_data := SQLCODE || ' : ' || SQLERRM;
366: x_msg_count := 1;
367: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,