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.AHL_MC_ITEM_COMP_PUB dependencies on FND_API

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

6: PROCEDURE Convert_code_to_ID(p_x_item_comp_rec IN OUT NOCOPY ahl_mc_item_comp_pvt.Detail_Rec_Type);
7:
8: PROCEDURE Process_Item_Composition(
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_module_type IN VARCHAR2 := NULL,
14: x_return_status OUT NOCOPY VARCHAR2,

Line 11: p_commit IN VARCHAR2 := FND_API.G_FALSE,

7:
8: PROCEDURE Process_Item_Composition(
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_module_type IN VARCHAR2 := NULL,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,

Line 12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8: PROCEDURE Process_Item_Composition(
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE,
12: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13: p_module_type IN VARCHAR2 := NULL,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,

Line 21: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

17: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
18: p_x_ic_det_tbl IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Det_Tbl_Type
19: ) AS
20:
21: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
22:
23:
24: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
25: SELECT organization_id

Line 56: IF FND_API.to_boolean(l_init_msg_list) THEN

52:
53:
54: -- Standard call to check for call compatibility.
55:
56: IF FND_API.to_boolean(l_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: -- Initialize API return status to success

Line 62: x_return_status :=FND_API.G_RET_STS_SUCCESS;

58: END IF;
59:
60: -- Initialize API return status to success
61:
62: x_return_status :=FND_API.G_RET_STS_SUCCESS;
63:
64: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
65: THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 149: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145:
146: IF l_msg_count > 0
147: THEN
148: X_msg_count := l_msg_count;
149: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: IF p_x_ic_header_rec.operation_flag = 'C' THEN

Line 150: RAISE FND_API.G_EXC_ERROR;

146: IF l_msg_count > 0
147: THEN
148: X_msg_count := l_msg_count;
149: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: IF p_x_ic_header_rec.operation_flag = 'C' THEN
154:

Line 157: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

153: IF p_x_ic_header_rec.operation_flag = 'C' THEN
154:
155: ahl_mc_item_comp_pvt.Create_Item_Composition(
156: p_api_version => p_api_version,
157: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status => x_return_status,
161: x_msg_count => x_msg_count,

Line 158: --p_commit IN VARCHAR2 := FND_API.G_FALSE,

154:
155: ahl_mc_item_comp_pvt.Create_Item_Composition(
156: p_api_version => p_api_version,
157: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status => x_return_status,
161: x_msg_count => x_msg_count,
162: x_msg_data => x_msg_data,

Line 159: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

155: ahl_mc_item_comp_pvt.Create_Item_Composition(
156: p_api_version => p_api_version,
157: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
159: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160: x_return_status => x_return_status,
161: x_msg_count => x_msg_count,
162: x_msg_data => x_msg_data,
163: p_x_ic_header_rec => p_x_ic_header_rec,

Line 170: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

166: ELSIF p_x_ic_header_rec.operation_flag = 'M' THEN
167:
168: ahl_mc_item_comp_pvt.Modify_Item_Composition(
169: p_api_version => p_api_version,
170: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: x_return_status => x_return_status,
174: x_msg_count => x_msg_count,

Line 171: --p_commit IN VARCHAR2 := FND_API.G_FALSE,

167:
168: ahl_mc_item_comp_pvt.Modify_Item_Composition(
169: p_api_version => p_api_version,
170: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: x_return_status => x_return_status,
174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data,

Line 172: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

168: ahl_mc_item_comp_pvt.Modify_Item_Composition(
169: p_api_version => p_api_version,
170: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: x_return_status => x_return_status,
174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data,
176: p_x_ic_header_rec => p_x_ic_header_rec,

Line 194: IF FND_API.TO_BOOLEAN(p_commit) THEN

190: p_object_version_number => p_x_ic_header_rec.object_version_number);
191:
192: END IF;
193:
194: IF FND_API.TO_BOOLEAN(p_commit) THEN
195: COMMIT WORK;
196: END IF;
197:
198: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 206: WHEN FND_API.G_EXC_ERROR THEN

202: END IF;
203:
204:
205: EXCEPTION
206: WHEN FND_API.G_EXC_ERROR THEN
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: Rollback to Process_Item_Composition;
209: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
210: p_data => x_msg_data,

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203:
204:
205: EXCEPTION
206: WHEN FND_API.G_EXC_ERROR THEN
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: Rollback to Process_Item_Composition;
209: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
210: p_data => x_msg_data,
211: p_encoded => fnd_api.g_false);

Line 211: p_encoded => fnd_api.g_false);

207: x_return_status := FND_API.G_RET_STS_ERROR;
208: Rollback to Process_Item_Composition;
209: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
210: p_data => x_msg_data,
211: p_encoded => fnd_api.g_false);
212:
213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
214: THEN
215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

216: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Error in Process_Item_Composition');
217: END IF;
218:
219:
220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: Rollback to Process_Item_Composition;
223: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
224: p_data => x_msg_data,

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: END IF;
218:
219:
220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: Rollback to Process_Item_Composition;
223: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
224: p_data => x_msg_data,
225: p_encoded => fnd_api.g_false);

Line 225: p_encoded => fnd_api.g_false);

221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: Rollback to Process_Item_Composition;
223: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
224: p_data => x_msg_data,
225: p_encoded => fnd_api.g_false);
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
228: THEN
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: 'ahl.plsql.'||G_PKG_NAME||'.Process_Item_Composition', 'Unexpected Error in Process_Item_Composition');
231: END IF;
232:
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: Rollback to Process_Item_Composition;
236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
237: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
238: p_procedure_name => 'Process_Item_Composition',

Line 243: p_encoded => fnd_api.g_false);

239: p_error_text => SUBSTR(SQLERRM,1,240));
240: END IF;
241: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
242: p_data => x_msg_data,
243: p_encoded => fnd_api.g_false);
244:
245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
246: THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 329: (l_item_comp_rec.inventory_org_id = FND_API.G_MISS_NUM)

325:
326:
327: -- For Inventory Organization Code.
328: IF (l_item_comp_rec.inventory_org_id IS NULL) OR
329: (l_item_comp_rec.inventory_org_id = FND_API.G_MISS_NUM)
330: THEN
331: -- if code is present.
332: IF (l_item_comp_rec.inventory_org_code IS NOT NULL) AND
333: (l_item_comp_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN

Line 333: (l_item_comp_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN

329: (l_item_comp_rec.inventory_org_id = FND_API.G_MISS_NUM)
330: THEN
331: -- if code is present.
332: IF (l_item_comp_rec.inventory_org_code IS NOT NULL) AND
333: (l_item_comp_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
334: OPEN mtl_parameters_csr (l_item_comp_rec.inventory_org_code);
335: FETCH mtl_parameters_csr INTO l_inventory_org_id;
336: IF (mtl_parameters_csr%FOUND) THEN
337: l_item_comp_rec.inventory_org_id := l_inventory_org_id;

Line 354: (l_item_comp_rec.inventory_item_id = FND_API.G_MISS_NUM)

350: END IF;
351:
352: -- For Inventory item.
353: IF (l_item_comp_rec.inventory_item_id IS NULL) OR
354: (l_item_comp_rec.inventory_item_id = FND_API.G_MISS_NUM)
355: THEN
356: -- check if name exists.
357: IF (l_item_comp_rec.inventory_item_name IS NOT NULL) AND
358: (l_item_comp_rec.inventory_item_name <> FND_API.G_MISS_CHAR) THEN

Line 358: (l_item_comp_rec.inventory_item_name <> FND_API.G_MISS_CHAR) THEN

354: (l_item_comp_rec.inventory_item_id = FND_API.G_MISS_NUM)
355: THEN
356: -- check if name exists.
357: IF (l_item_comp_rec.inventory_item_name IS NOT NULL) AND
358: (l_item_comp_rec.inventory_item_name <> FND_API.G_MISS_CHAR) THEN
359:
360: OPEN mtl_system_items_csr(l_item_comp_rec.inventory_item_name,
361: l_item_comp_rec.inventory_org_id);
362: FETCH mtl_system_items_csr INTO l_inventory_id;