DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PUB dependencies on FND_MESSAGE

Line 81: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');

77: FETCH mtl_parameters_csr INTO l_inv_org_id;
78: IF (mtl_parameters_csr%FOUND) THEN
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

Line 82: FND_MESSAGE.Set_Token('ORG',p_x_ic_header_rec.inventory_org_code);

78: IF (mtl_parameters_csr%FOUND) THEN
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');

Line 86: FND_MESSAGE.SET_NAME('AHL','AHL_MC_ORG_NULL');

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;
88: END IF;
89: END IF; -- end of inventory_org_id condition.
90:

Line 100: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');

96: FETCH mtl_system_items_csr INTO l_inv_item_id;
97: IF (mtl_system_items_csr%FOUND) THEN
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

Line 101: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_name);

97: IF (mtl_system_items_csr%FOUND) THEN
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');

Line 105: FND_MESSAGE.SET_NAME('AHL','AHL_MC_INV_NULL');

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;
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,

Line 113: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');

109: OPEN mtl_segment_csr(p_x_ic_header_rec.inventory_item_id,
110: p_x_ic_header_rec.inventory_org_id);
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;

Line 114: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_id);

110: p_x_ic_header_rec.inventory_org_id);
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;

Line 316: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_IG_INVALID');

312: FETCH get_itemGroup_csr INTO l_item_group_id;
313: IF (get_itemGroup_csr%FOUND) THEN
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;

Line 317: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_comp_rec.item_group_name);

313: IF (get_itemGroup_csr%FOUND) THEN
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;

Line 339: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');

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;
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;

Line 340: FND_MESSAGE.Set_Token('ORG',l_item_comp_rec.inventory_org_code);

336: IF (mtl_parameters_csr%FOUND) THEN
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

Line 346: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_NULL');

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.
346: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_NULL');
347: FND_MSG_PUB.ADD;
348: END IF;
349:
350: END IF;

Line 367: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');

363: IF (mtl_system_items_csr%FOUND) THEN
364: l_item_comp_rec.inventory_item_id := l_inventory_id;
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;

Line 368: FND_MESSAGE.Set_Token('INV_ITEM',l_item_comp_rec.inventory_item_name);

364: l_item_comp_rec.inventory_item_id := l_inventory_id;
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

Line 374: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');

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.
374: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
375: FND_MSG_PUB.ADD;
376: END IF;
377:
378: ELSE

Line 383: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');

379: OPEN mtl_segment_csr(l_item_comp_rec.inventory_item_id,
380: l_item_comp_rec.inventory_org_id);
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;

Line 384: FND_MESSAGE.Set_Token('INV_ITEM',l_item_comp_rec.inventory_item_id);

380: l_item_comp_rec.inventory_org_id);
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;