APPS.EAM_MATERIAL_REQUEST_PVT dependencies on FND_API

Line 52: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT ALLOCATE_EAM;
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
53: l_api_name, G_PKG_NAME )
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
53: l_api_name, G_PKG_NAME )
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;

Line 58: IF FND_API.to_Boolean( p_init_msg_list ) THEN

54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61: -- Initialize API return status to success
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58: IF FND_API.to_Boolean( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61: -- Initialize API return status to success
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: -- API body
65: l_msg_data := NULL;
66: l_return_status := NULL;

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: if (p_requested_quantity = 0) then
72: return;
73: end if;
74: if (p_requested_quantity < 0) then
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_message.set_name('EAM','EAM_MR_NEGATIVE_REQ_QTY');
77: fnd_message.set_token('REQUESTED', to_char(p_requested_quantity) );
78: fnd_msg_pub.add;
79: FND_MSG_PUB.Count_And_Get(

Line 109: if (p_project_id = FND_API.G_MISS_NUM) then

105: select project_id, task_id into l_project_id, l_task_id
106: from wip_discrete_jobs
107: where wip_entity_id = p_wip_entity_id;
108: else
109: if (p_project_id = FND_API.G_MISS_NUM) then
110: l_project_id := null;
111: end if;
112: if (p_task_id = FND_API.G_MISS_NUM) then
113: l_task_id := null;

Line 112: if (p_task_id = FND_API.G_MISS_NUM) then

108: else
109: if (p_project_id = FND_API.G_MISS_NUM) then
110: l_project_id := null;
111: end if;
112: if (p_task_id = FND_API.G_MISS_NUM) then
113: l_task_id := null;
114: end if;
115: end if;
116: allocate_table(1).wip_entity_id := p_wip_entity_id;

Line 180: if (x_return_status = FND_API.G_RET_STS_ERROR) then

176: fnd_msg_pub.add;
177: end if;
178: end if;
179:
180: if (x_return_status = FND_API.G_RET_STS_ERROR) then
181: if l_msg_data is null then --should not happen, just a safeguard
182: fnd_message.set_name('EAM','EAM_MR_ALLOCATION_FAILED');
183: fnd_msg_pub.add;
184: end if;

Line 185: RAISE FND_API.G_EXC_ERROR;

181: if l_msg_data is null then --should not happen, just a safeguard
182: fnd_message.set_name('EAM','EAM_MR_ALLOCATION_FAILED');
183: fnd_msg_pub.add;
184: end if;
185: RAISE FND_API.G_EXC_ERROR;
186: end if;
187: -- End of API body.
188:
189: -- Standard check of p_commit.

Line 190: IF FND_API.To_Boolean( p_commit ) THEN

186: end if;
187: -- End of API body.
188:
189: -- Standard check of p_commit.
190: IF FND_API.To_Boolean( p_commit ) THEN
191: COMMIT WORK;
192: END IF;
193:
194: -- Standard call to get message count and if count is 1, get message info.

Line 202: WHEN FND_API.G_EXC_ERROR THEN

198: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
199: 'End of ' || l_full_name );
200: end if;
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO ALLOCATE_EAM;
204: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
206: 'Exception Block 1 - Expected Error' );

Line 208: x_return_status := FND_API.G_RET_STS_ERROR ;

204: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
206: 'Exception Block 1 - Expected Error' );
207: END IF;
208: x_return_status := FND_API.G_RET_STS_ERROR ;
209: FND_MSG_PUB.Count_And_Get(
210: p_count => x_msg_count,
211: p_data => x_msg_data);
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

208: x_return_status := FND_API.G_RET_STS_ERROR ;
209: FND_MSG_PUB.Count_And_Get(
210: p_count => x_msg_count,
211: p_data => x_msg_data);
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: ROLLBACK TO ALLOCATE_EAM;
214: IF ( l_uLog ) THEN
215: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
216: 'Exception Block 2 - Unexpected error' );

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

214: IF ( l_uLog ) THEN
215: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
216: 'Exception Block 2 - Unexpected error' );
217: END IF ;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219: FND_MSG_PUB.Count_And_Get(
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222: WHEN OTHERS THEN

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

224: IF ( l_uLog ) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
226: 'Exception Block 3 - Others' );
227: END IF ;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
232: END IF;

Line 563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));

559: fnd_file.put_line(which => fnd_file.output, buff => '');
560: fnd_message.set_name('WIP', 'ERROR_DIALOG_TITLE');
561: fnd_file.put_line(which => fnd_file.output, buff => fnd_message.get);
562: for i in 1..l_msgCount loop
563: fnd_file.put_line(which => fnd_file.output, buff => fnd_msg_pub.get(p_msg_index => l_msgCount - i + 1, p_encoded => fnd_api.g_false));
564: end loop;
565: rollback to eam_allocate_concurrent;
566: end allocate_comp_mat;
567: