DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PUB dependencies on FND_MSG_PUB

Line 57: FND_MSG_PUB.initialize;

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
61:

Line 83: FND_MSG_PUB.ADD;

79: p_x_ic_header_rec.inventory_org_id := l_inv_org_id;
80: ELSE
81: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
82: FND_MESSAGE.Set_Token('ORG',p_x_ic_header_rec.inventory_org_code);
83: FND_MSG_PUB.ADD;
84: END IF;
85: ELSE
86: FND_MESSAGE.SET_NAME('AHL','AHL_MC_ORG_NULL');
87: FND_MSG_PUB.ADD;

Line 87: FND_MSG_PUB.ADD;

83: FND_MSG_PUB.ADD;
84: END IF;
85: ELSE
86: FND_MESSAGE.SET_NAME('AHL','AHL_MC_ORG_NULL');
87: FND_MSG_PUB.ADD;
88: END IF;
89: END IF; -- end of inventory_org_id condition.
90:
91: IF p_x_ic_header_rec.inventory_item_id IS NULL THEN

Line 102: FND_MSG_PUB.ADD;

98: p_x_ic_header_rec.inventory_item_id := l_inv_item_id;
99: ELSE
100: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
101: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_name);
102: FND_MSG_PUB.ADD;
103: END IF;
104: ELSE
105: FND_MESSAGE.SET_NAME('AHL','AHL_MC_INV_NULL');
106: FND_MSG_PUB.ADD;

Line 106: FND_MSG_PUB.ADD;

102: FND_MSG_PUB.ADD;
103: END IF;
104: ELSE
105: FND_MESSAGE.SET_NAME('AHL','AHL_MC_INV_NULL');
106: FND_MSG_PUB.ADD;
107: END IF;
108: ELSIF p_x_ic_header_rec.inventory_item_id IS NOT NULL THEN
109: OPEN mtl_segment_csr(p_x_ic_header_rec.inventory_item_id,
110: p_x_ic_header_rec.inventory_org_id);

Line 115: FND_MSG_PUB.ADD;

111: FETCH mtl_segment_csr INTO l_item_name;
112: IF (mtl_segment_csr%NOTFOUND) THEN
113: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
114: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_id);
115: FND_MSG_PUB.ADD;
116: ELSE
117: p_x_ic_header_rec.inventory_item_name := l_item_name;
118: END IF;
119: CLOSE mtl_segment_csr;

Line 144: l_msg_count := FND_MSG_PUB.count_msg;

140: End Loop;
141:
142: END IF;
143:
144: l_msg_count := FND_MSG_PUB.count_msg;
145:
146: IF l_msg_count > 0
147: THEN
148: X_msg_count := l_msg_count;

Line 209: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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);
212:
213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 223: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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);
226:
227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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',
239: p_error_text => SUBSTR(SQLERRM,1,240));
240: END IF;

Line 237: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

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',
239: p_error_text => SUBSTR(SQLERRM,1,240));
240: END IF;
241: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 241: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

237: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
238: p_procedure_name => 'Process_Item_Composition',
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 )

Line 318: FND_MSG_PUB.ADD;

314: l_item_comp_rec.item_group_id := l_item_group_id;
315: ELSE
316: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_IG_INVALID');
317: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_comp_rec.item_group_name);
318: FND_MSG_PUB.ADD;
319: END IF;
320: CLOSE get_itemGroup_csr;
321: END IF;
322:

Line 341: FND_MSG_PUB.ADD;

337: l_item_comp_rec.inventory_org_id := l_inventory_org_id;
338: ELSE
339: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
340: FND_MESSAGE.Set_Token('ORG',l_item_comp_rec.inventory_org_code);
341: FND_MSG_PUB.ADD;
342: END IF;
343: CLOSE mtl_parameters_csr;
344: ELSIF (l_item_comp_rec.operation_flag = 'C') THEN
345: -- Both ID and code are missing.

Line 347: FND_MSG_PUB.ADD;

343: CLOSE mtl_parameters_csr;
344: ELSIF (l_item_comp_rec.operation_flag = 'C') THEN
345: -- Both ID and code are missing.
346: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_NULL');
347: FND_MSG_PUB.ADD;
348: END IF;
349:
350: END IF;
351:

Line 369: FND_MSG_PUB.ADD;

365:
366: ELSE
367: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
368: FND_MESSAGE.Set_Token('INV_ITEM',l_item_comp_rec.inventory_item_name);
369: FND_MSG_PUB.ADD;
370: END IF;
371: CLOSE mtl_system_items_csr;
372: ELSIF (l_item_comp_rec.operation_flag = 'C') THEN
373: -- Both ID and name missing.

Line 375: FND_MSG_PUB.ADD;

371: CLOSE mtl_system_items_csr;
372: ELSIF (l_item_comp_rec.operation_flag = 'C') THEN
373: -- Both ID and name missing.
374: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
375: FND_MSG_PUB.ADD;
376: END IF;
377:
378: ELSE
379: OPEN mtl_segment_csr(l_item_comp_rec.inventory_item_id,

Line 385: FND_MSG_PUB.ADD;

381: FETCH mtl_segment_csr INTO l_concatenated_segments;
382: IF (mtl_segment_csr%NOTFOUND) THEN
383: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
384: FND_MESSAGE.Set_Token('INV_ITEM',l_item_comp_rec.inventory_item_id);
385: FND_MSG_PUB.ADD;
386: ELSE
387: l_item_comp_rec.inventory_item_name := l_concatenated_segments;
388: END IF;
389: CLOSE mtl_segment_csr;