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_PVT dependencies on FND_MESSAGE

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

49: -- For organization code
50: OPEN mtl_parameters_csr(p_inventory_org_id);
51: FETCH mtl_parameters_csr INTO l_organization_code,l_master_org_id;
52: IF (mtl_parameters_csr%NOTFOUND) THEN
53: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
54: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
55: FND_MSG_PUB.ADD;
56: ELSE
57: p_master_org_id := l_master_org_id;

Line 54: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);

50: OPEN mtl_parameters_csr(p_inventory_org_id);
51: FETCH mtl_parameters_csr INTO l_organization_code,l_master_org_id;
52: IF (mtl_parameters_csr%NOTFOUND) THEN
53: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
54: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
55: FND_MSG_PUB.ADD;
56: ELSE
57: p_master_org_id := l_master_org_id;
58: /*IF l_master_org_id <> p_master_org_id THEN

Line 59: FND_MESSAGE.Set_Name('AHL','AHL_MC_MASTER_ORG_INVALID');

55: FND_MSG_PUB.ADD;
56: ELSE
57: p_master_org_id := l_master_org_id;
58: /*IF l_master_org_id <> p_master_org_id THEN
59: FND_MESSAGE.Set_Name('AHL','AHL_MC_MASTER_ORG_INVALID');
60: FND_MESSAGE.Set_Token('ORG',p_master_org_id);
61: FND_MSG_PUB.ADD;
62: */
63: END IF;

Line 60: FND_MESSAGE.Set_Token('ORG',p_master_org_id);

56: ELSE
57: p_master_org_id := l_master_org_id;
58: /*IF l_master_org_id <> p_master_org_id THEN
59: FND_MESSAGE.Set_Name('AHL','AHL_MC_MASTER_ORG_INVALID');
60: FND_MESSAGE.Set_Token('ORG',p_master_org_id);
61: FND_MSG_PUB.ADD;
62: */
63: END IF;
64: CLOSE mtl_parameters_csr;

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

74: -- removing this appending logic
75: -- l_segment1 := l_segment1 || ',' || l_organization_code;
76:
77: IF (mtl_system_items_non_ou_csr%NOTFOUND) THEN
78: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
79: FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
80: FND_MSG_PUB.ADD;
81: --dbms_output.put_line('Inventory item does not exist');
82:

Line 79: FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);

75: -- l_segment1 := l_segment1 || ',' || l_organization_code;
76:
77: IF (mtl_system_items_non_ou_csr%NOTFOUND) THEN
78: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
79: FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
80: FND_MSG_PUB.ADD;
81: --dbms_output.put_line('Inventory item does not exist');
82:
83: l_segment1 := null;

Line 91: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');

87: ELSE
88:
89: IF ( UPPER(p_record_type) = 'HEADER' AND UPPER(l_instance_track) <> 'Y')
90: THEN
91: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');
92: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
93: FND_MSG_PUB.ADD;
94: --dbms_output.put_line('Rec Type '||p_record_type || ' and '||l_instance_track);
95: ELSIF ( UPPER(p_record_type) = 'DETAIL' AND UPPER(l_instance_track) = 'Y')

Line 92: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);

88:
89: IF ( UPPER(p_record_type) = 'HEADER' AND UPPER(l_instance_track) <> 'Y')
90: THEN
91: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');
92: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
93: FND_MSG_PUB.ADD;
94: --dbms_output.put_line('Rec Type '||p_record_type || ' and '||l_instance_track);
95: ELSIF ( UPPER(p_record_type) = 'DETAIL' AND UPPER(l_instance_track) = 'Y')
96: THEN

Line 97: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NON_TRACK');

93: FND_MSG_PUB.ADD;
94: --dbms_output.put_line('Rec Type '||p_record_type || ' and '||l_instance_track);
95: ELSIF ( UPPER(p_record_type) = 'DETAIL' AND UPPER(l_instance_track) = 'Y')
96: THEN
97: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NON_TRACK');
98: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
99: FND_MSG_PUB.ADD;
100: --dbms_output.put_line('Inventory item are trackable');
101: END IF;

Line 98: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);

94: --dbms_output.put_line('Rec Type '||p_record_type || ' and '||l_instance_track);
95: ELSIF ( UPPER(p_record_type) = 'DETAIL' AND UPPER(l_instance_track) = 'Y')
96: THEN
97: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NON_TRACK');
98: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
99: FND_MSG_PUB.ADD;
100: --dbms_output.put_line('Inventory item are trackable');
101: END IF;
102:

Line 136: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_NULL');

132: -- Check if UOM entered and valid.
133: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
134: -- uom_code is null but quantity is not null.
135: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
136: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_NULL');
137: FND_MESSAGE.Set_Token('IG',p_item_group_name);
138: FND_MSG_PUB.ADD;
139: ELSE
140: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');

Line 137: FND_MESSAGE.Set_Token('IG',p_item_group_name);

133: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
134: -- uom_code is null but quantity is not null.
135: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
136: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_NULL');
137: FND_MESSAGE.Set_Token('IG',p_item_group_name);
138: FND_MSG_PUB.ADD;
139: ELSE
140: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');
141: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

Line 140: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');

136: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_NULL');
137: FND_MESSAGE.Set_Token('IG',p_item_group_name);
138: FND_MSG_PUB.ADD;
139: ELSE
140: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');
141: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
142: FND_MSG_PUB.ADD;
143: END IF;
144: --dbms_output.put_line('Uom is null');

Line 141: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

137: FND_MESSAGE.Set_Token('IG',p_item_group_name);
138: FND_MSG_PUB.ADD;
139: ELSE
140: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');
141: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
142: FND_MSG_PUB.ADD;
143: END IF;
144: --dbms_output.put_line('Uom is null');
145: ELSIF p_inventory_item_id IS NOT NULL AND p_inventory_org_id IS NOT NULL THEN

Line 150: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');

146: IF NOT(inv_convert.Validate_Item_Uom(p_item_id => p_inventory_item_id,
147: p_organization_id => p_inventory_org_id,
148: p_uom_code => p_uom_code))
149: THEN
150: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');
151: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
152: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
153: FND_MSG_PUB.ADD;
154: --dbms_output.put_line('Invalid UOM code for the item');

Line 151: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);

147: p_organization_id => p_inventory_org_id,
148: p_uom_code => p_uom_code))
149: THEN
150: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');
151: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
152: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
153: FND_MSG_PUB.ADD;
154: --dbms_output.put_line('Invalid UOM code for the item');
155: END IF;

Line 152: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

148: p_uom_code => p_uom_code))
149: THEN
150: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');
151: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
152: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
153: FND_MSG_PUB.ADD;
154: --dbms_output.put_line('Invalid UOM code for the item');
155: END IF;
156: ELSIF p_item_group_name IS NOT NULL THEN

Line 160: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_INVALID');

156: ELSIF p_item_group_name IS NOT NULL THEN
157: OPEN validate_uom(p_uom_code);
158: FETCH validate_uom INTO l_uom_code;
159: IF validate_uom%NOTFOUND THEN
160: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_INVALID');
161: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
162: FND_MESSAGE.Set_Token('IG',p_item_group_name);
163: FND_MSG_PUB.ADD;
164: END IF;

Line 161: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);

157: OPEN validate_uom(p_uom_code);
158: FETCH validate_uom INTO l_uom_code;
159: IF validate_uom%NOTFOUND THEN
160: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_INVALID');
161: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
162: FND_MESSAGE.Set_Token('IG',p_item_group_name);
163: FND_MSG_PUB.ADD;
164: END IF;
165: END IF ;

Line 162: FND_MESSAGE.Set_Token('IG',p_item_group_name);

158: FETCH validate_uom INTO l_uom_code;
159: IF validate_uom%NOTFOUND THEN
160: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_INVALID');
161: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
162: FND_MESSAGE.Set_Token('IG',p_item_group_name);
163: FND_MSG_PUB.ADD;
164: END IF;
165: END IF ;
166:

Line 170: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_NULL');

166:
167: -- Validate quantity.
168: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
169: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
170: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_NULL');
171: FND_MESSAGE.Set_Token('IG',p_item_group_name);
172: FND_MSG_PUB.ADD;
173: ELSE
174: FND_MESSAGE.Set_Name('AHL','AHL_MC_QTY_NULL');

Line 171: FND_MESSAGE.Set_Token('IG',p_item_group_name);

167: -- Validate quantity.
168: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
169: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
170: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_NULL');
171: FND_MESSAGE.Set_Token('IG',p_item_group_name);
172: FND_MSG_PUB.ADD;
173: ELSE
174: FND_MESSAGE.Set_Name('AHL','AHL_MC_QTY_NULL');
175: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

Line 174: FND_MESSAGE.Set_Name('AHL','AHL_MC_QTY_NULL');

170: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_NULL');
171: FND_MESSAGE.Set_Token('IG',p_item_group_name);
172: FND_MSG_PUB.ADD;
173: ELSE
174: FND_MESSAGE.Set_Name('AHL','AHL_MC_QTY_NULL');
175: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
176: FND_MSG_PUB.ADD;
177: END IF;
178: --dbms_output.put_line('Quantity is null');

Line 175: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

171: FND_MESSAGE.Set_Token('IG',p_item_group_name);
172: FND_MSG_PUB.ADD;
173: ELSE
174: FND_MESSAGE.Set_Name('AHL','AHL_MC_QTY_NULL');
175: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
176: FND_MSG_PUB.ADD;
177: END IF;
178: --dbms_output.put_line('Quantity is null');
179: ELSIF (p_quantity < 0) THEN

Line 181: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_INVALID');

177: END IF;
178: --dbms_output.put_line('Quantity is null');
179: ELSIF (p_quantity < 0) THEN
180: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
181: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_INVALID');
182: FND_MESSAGE.Set_Token('IG',p_item_group_name);
183: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
184: FND_MSG_PUB.ADD;
185: ELSE

Line 182: FND_MESSAGE.Set_Token('IG',p_item_group_name);

178: --dbms_output.put_line('Quantity is null');
179: ELSIF (p_quantity < 0) THEN
180: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
181: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_INVALID');
182: FND_MESSAGE.Set_Token('IG',p_item_group_name);
183: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
184: FND_MSG_PUB.ADD;
185: ELSE
186: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');

Line 183: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);

179: ELSIF (p_quantity < 0) THEN
180: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
181: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_INVALID');
182: FND_MESSAGE.Set_Token('IG',p_item_group_name);
183: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
184: FND_MSG_PUB.ADD;
185: ELSE
186: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
187: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

Line 186: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');

182: FND_MESSAGE.Set_Token('IG',p_item_group_name);
183: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
184: FND_MSG_PUB.ADD;
185: ELSE
186: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
187: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
188: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
189: FND_MSG_PUB.ADD;
190: END IF;

Line 187: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

183: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
184: FND_MSG_PUB.ADD;
185: ELSE
186: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
187: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
188: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
189: FND_MSG_PUB.ADD;
190: END IF;
191: --dbms_output.put_line('Invalid quantity');

Line 188: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);

184: FND_MSG_PUB.ADD;
185: ELSE
186: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
187: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
188: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
189: FND_MSG_PUB.ADD;
190: END IF;
191: --dbms_output.put_line('Invalid quantity');
192: END IF;

Line 257: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_INVALID_HEADER');

253:
254: --dbms_output.put_line(l_Detail_Rec_Type.item_composition_id ||'--'|| p_item_composition_id);
255: -- SATHAPLI::Bug 9891860, 20-July-2010, replaced the following two non-existent error messages with existing ones
256: IF NVL(l_Detail_Rec_Type.item_composition_id,0) <> NVL(p_item_composition_id,0) THEN
257: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_INVALID_HEADER');
258: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_HEADER_MISMATCH'); -- Item Composition header is invalid.
259: FND_MSG_PUB.ADD;
260: END IF;
261:

Line 258: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_HEADER_MISMATCH'); -- Item Composition header is invalid.

254: --dbms_output.put_line(l_Detail_Rec_Type.item_composition_id ||'--'|| p_item_composition_id);
255: -- SATHAPLI::Bug 9891860, 20-July-2010, replaced the following two non-existent error messages with existing ones
256: IF NVL(l_Detail_Rec_Type.item_composition_id,0) <> NVL(p_item_composition_id,0) THEN
257: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_INVALID_HEADER');
258: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_HEADER_MISMATCH'); -- Item Composition header is invalid.
259: FND_MSG_PUB.ADD;
260: END IF;
261:
262: OPEN get_item_comp_det(p_item_composition_id,l_Detail_Rec_Type.item_comp_detail_id);

Line 265: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DETAIL_NO_EXIST');

261:
262: OPEN get_item_comp_det(p_item_composition_id,l_Detail_Rec_Type.item_comp_detail_id);
263: FETCH get_item_comp_det INTO l_dummy;
264: IF get_item_comp_det%NOTFOUND THEN
265: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DETAIL_NO_EXIST');
266: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IC_INVALID'); -- Invalid composition item ITEM.
267: FND_MESSAGE.Set_Token('ITEM', l_Detail_Rec_Type.inventory_item_name);
268: FND_MSG_PUB.ADD;
269: END IF;

Line 266: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IC_INVALID'); -- Invalid composition item ITEM.

262: OPEN get_item_comp_det(p_item_composition_id,l_Detail_Rec_Type.item_comp_detail_id);
263: FETCH get_item_comp_det INTO l_dummy;
264: IF get_item_comp_det%NOTFOUND THEN
265: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DETAIL_NO_EXIST');
266: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IC_INVALID'); -- Invalid composition item ITEM.
267: FND_MESSAGE.Set_Token('ITEM', l_Detail_Rec_Type.inventory_item_name);
268: FND_MSG_PUB.ADD;
269: END IF;
270: CLOSE get_item_comp_det;

Line 267: FND_MESSAGE.Set_Token('ITEM', l_Detail_Rec_Type.inventory_item_name);

263: FETCH get_item_comp_det INTO l_dummy;
264: IF get_item_comp_det%NOTFOUND THEN
265: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DETAIL_NO_EXIST');
266: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IC_INVALID'); -- Invalid composition item ITEM.
267: FND_MESSAGE.Set_Token('ITEM', l_Detail_Rec_Type.inventory_item_name);
268: FND_MSG_PUB.ADD;
269: END IF;
270: CLOSE get_item_comp_det;
271:

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

278: OPEN validate_item_group(l_Detail_Rec_Type.item_group_name,
279: l_Detail_Rec_Type.item_group_id);
280: FETCH validate_item_group INTO l_dummy;
281: IF validate_item_group%NOTFOUND THEN
282: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_IG_INVALID');
283: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);
284: FND_MSG_PUB.ADD;
285: END IF;
286: CLOSE validate_item_group;

Line 283: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);

279: l_Detail_Rec_Type.item_group_id);
280: FETCH validate_item_group INTO l_dummy;
281: IF validate_item_group%NOTFOUND THEN
282: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_IG_INVALID');
283: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);
284: FND_MSG_PUB.ADD;
285: END IF;
286: CLOSE validate_item_group;
287:

Line 293: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_IG_EXISTS');

289: OPEN item_group_exists(l_Detail_Rec_Type.item_group_id,
290: p_item_composition_id);
291: FETCH item_group_exists INTO l_dummy;
292: IF item_group_exists%FOUND THEN
293: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_IG_EXISTS');
294: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);
295: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);
296:
297: FND_MSG_PUB.ADD;

Line 294: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);

290: p_item_composition_id);
291: FETCH item_group_exists INTO l_dummy;
292: IF item_group_exists%FOUND THEN
293: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_IG_EXISTS');
294: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);
295: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);
296:
297: FND_MSG_PUB.ADD;
298: END IF;

Line 295: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);

291: FETCH item_group_exists INTO l_dummy;
292: IF item_group_exists%FOUND THEN
293: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_IG_EXISTS');
294: FND_MESSAGE.set_token('ITEM_GRP',l_Detail_Rec_Type.item_group_name);
295: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);
296:
297: FND_MSG_PUB.ADD;
298: END IF;
299: CLOSE item_group_exists;

Line 317: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_INV_EXISTS');

313: p_item_composition_id);
314: FETCH inv_item_exists INTO l_dummy;
315: IF inv_item_exists%FOUND THEN
316: IF l_Detail_Rec_Type.operation_flag ='C' THEN
317: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_INV_EXISTS');
318: FND_MESSAGE.set_token('INV_ITM',l_Detail_Rec_Type.inventory_item_name);
319: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);
320: FND_MSG_PUB.ADD;
321: END IF;

Line 318: FND_MESSAGE.set_token('INV_ITM',l_Detail_Rec_Type.inventory_item_name);

314: FETCH inv_item_exists INTO l_dummy;
315: IF inv_item_exists%FOUND THEN
316: IF l_Detail_Rec_Type.operation_flag ='C' THEN
317: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_INV_EXISTS');
318: FND_MESSAGE.set_token('INV_ITM',l_Detail_Rec_Type.inventory_item_name);
319: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);
320: FND_MSG_PUB.ADD;
321: END IF;
322: ELSE

Line 319: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);

315: IF inv_item_exists%FOUND THEN
316: IF l_Detail_Rec_Type.operation_flag ='C' THEN
317: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_INV_EXISTS');
318: FND_MESSAGE.set_token('INV_ITM',l_Detail_Rec_Type.inventory_item_name);
319: FND_MESSAGE.set_token('INV_ITEM',p_inv_item_name);
320: FND_MSG_PUB.ADD;
321: END IF;
322: ELSE
323: IF l_Detail_Rec_Type.operation_flag ='M' THEN

Line 324: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_INV_NOEXISTS');

320: FND_MSG_PUB.ADD;
321: END IF;
322: ELSE
323: IF l_Detail_Rec_Type.operation_flag ='M' THEN
324: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_INV_NOEXISTS');
325: FND_MSG_PUB.ADD;
326: END IF;
327: END IF;
328: CLOSE inv_item_exists;

Line 348: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_ASSOS_NULL');

344: l_Detail_Rec_Type.operation_flag <>'D') OR
345: (l_Detail_Rec_Type.inventory_item_id IS NOT NULL AND
346: l_Detail_Rec_Type.item_group_name IS NOT NULL )
347: THEN
348: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_ASSOS_NULL');
349: FND_MSG_PUB.ADD;
350: END IF;
351:
352: IF l_Detail_Rec_Type.item_composition_id <> p_item_composition_id THEN

Line 353: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_HEADER_MISMATCH');

349: FND_MSG_PUB.ADD;
350: END IF;
351:
352: IF l_Detail_Rec_Type.item_composition_id <> p_item_composition_id THEN
353: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_HEADER_MISMATCH');
354: FND_MSG_PUB.ADD;
355: END IF;
356:
357: p_x_Detail_Rec_Type := l_Detail_Rec_Type;

Line 455: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');

451: OPEN item_composition_dup(p_x_ic_header_rec.INVENTORY_ITEM_ID,
452: p_x_ic_header_rec.INVENTORY_MASTER_ORG_ID);
453: FETCH item_composition_dup INTO l_dummy;
454: IF item_composition_dup%FOUND THEN
455: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');
456: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_name);
457: FND_MSG_PUB.ADD;
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;

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

452: p_x_ic_header_rec.INVENTORY_MASTER_ORG_ID);
453: FETCH item_composition_dup INTO l_dummy;
454: IF item_composition_dup%FOUND THEN
455: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');
456: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_name);
457: FND_MSG_PUB.ADD;
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;
460:

Line 743: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');

739: OPEN item_composition_det(p_x_ic_header_rec.item_composition_id
740: );
741: FETCH item_composition_det INTO l_item_composition_rec;
742: IF item_composition_det%NOTFOUND THEN
743: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');
744: FND_MSG_PUB.ADD;
745: RAISE FND_API.G_EXC_ERROR;
746: END IF;
747:

Line 755: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

751: -- SATHAPLI::Enigma Phase II integration, 03-Mar-2010, bypass the following two checks for Enigma sourced item groups
752: -- IF l_item_composition_rec.object_version_number <> p_x_ic_header_rec.object_version_number THEN
753: IF (NVL(l_item_composition_rec.sourced_from_enigma_flag, 'N') = 'N' AND
754: l_item_composition_rec.object_version_number <> p_x_ic_header_rec.object_version_number) THEN
755: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
756: FND_MSG_PUB.ADD;
757: RAISE FND_API.G_EXC_ERROR;
758: END IF;
759:

Line 764: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_EDIT');

760:
761: -- IF l_item_composition_rec.approval_status_code NOT IN ('DRAFT','APPROVAL_REJECTED') THEN
762: IF (NVL(l_item_composition_rec.sourced_from_enigma_flag, 'N') = 'N' AND
763: l_item_composition_rec.approval_status_code NOT IN ('DRAFT','APPROVAL_REJECTED')) THEN
764: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_EDIT');
765: FND_MSG_PUB.ADD;
766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768:

Line 1033: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');

1029: OPEN item_composition_det(p_item_composition_id
1030: );
1031: FETCH item_composition_det INTO l_item_composition_rec;
1032: IF item_composition_det%NOTFOUND THEN
1033: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');
1034: FND_MSG_PUB.ADD;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:

Line 1042: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1038: CLOSE item_composition_det;
1039:
1040:
1041: IF l_item_composition_rec.object_version_number <> p_object_version_number THEN
1042: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1043: FND_MSG_PUB.ADD;
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046:

Line 1049: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_DELETE');

1045: END IF;
1046:
1047:
1048: IF l_item_composition_rec.approval_status_code = 'APPROVAL_PENDING' THEN
1049: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_DELETE');
1050: FND_MSG_PUB.ADD;
1051: RAISE FND_API.G_EXC_ERROR;
1052: END IF;
1053:

Line 1068: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DISP_EXISTS');

1064: OPEN disposition_exist(p_item_composition_id
1065: );
1066: FETCH disposition_exist INTO l_dummy;
1067: IF disposition_exist%FOUND THEN
1068: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DISP_EXISTS');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:

Line 1078: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_REV_EXISTS');

1074:
1075: OPEN item_rev_exists(p_item_composition_id);
1076: FETCH item_rev_exists INTO l_rev_item_composition_id;
1077: IF item_rev_exists%FOUND THEN
1078: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_REV_EXISTS');
1079: FND_MSG_PUB.ADD;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082: CLOSE item_rev_exists;

Line 1087: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_DELETE');

1083:
1084:
1085: IF l_item_composition_rec.effective_end_date IS NOT NULL AND
1086: TRUNC(l_item_composition_rec.effective_end_date) <= TRUNC(SYSDATE) THEN
1087: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_DELETE');
1088: FND_MSG_PUB.ADD;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:

Line 1291: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');

1287:
1288: OPEN item_composition_det(p_item_composition_ID);
1289: FETCH item_composition_det INTO l_item_composition_rec;
1290: IF item_composition_det%NOTFOUND THEN
1291: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');
1292: FND_MSG_PUB.ADD;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295:

Line 1300: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1296: CLOSE item_composition_det;
1297:
1298:
1299: IF l_item_composition_rec.object_version_number <> p_object_version_number THEN
1300: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:

Line 1310: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');

1306: OPEN item_composition_exists(l_item_composition_rec.inventory_item_id,
1307: l_item_composition_rec.inventory_master_org_id);
1308: FETCH item_composition_exists INTO l_dummy;
1309: IF item_composition_exists%FOUND THEN
1310: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');
1311: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_id);
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;

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

1307: l_item_composition_rec.inventory_master_org_id);
1308: FETCH item_composition_exists INTO l_dummy;
1309: IF item_composition_exists%FOUND THEN
1310: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');
1311: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_id);
1312: FND_MSG_PUB.ADD;
1313: RAISE FND_API.G_EXC_ERROR;
1314: END IF;
1315:

Line 1321: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_OPEN');

1317: */
1318:
1319:
1320: IF NVL(l_item_composition_rec.effective_end_date,TRUNC(SYSDATE)) >= TRUNC(SYSDATE) THEN
1321: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_OPEN');
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325:

Line 1693: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');

1689:
1690:
1691: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
1692: THEN
1693: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
1694: FND_MSG_PUB.ADD;
1695: END IF;
1696:
1697: IF p_Item_Composition_id is null or p_Item_Composition_id = FND_API.G_MISS_NUM

Line 1699: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');

1695: END IF;
1696:
1697: IF p_Item_Composition_id is null or p_Item_Composition_id = FND_API.G_MISS_NUM
1698: THEN
1699: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
1700: FND_MSG_PUB.ADD;
1701: ELSE
1702:
1703: OPEN get_Item_comp_Det(p_Item_Composition_id);

Line 1714: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_EMPTY');

1710: from ahl_item_comp_details
1711: where item_composition_id = p_Item_Composition_id;
1712:
1713: IF l_count < 1 THEN
1714: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_EMPTY');
1715: FND_MESSAGE.Set_Token('ITEM_COMP',l_item_comp_rec.concatenated_segments);
1716: FND_MSG_PUB.ADD;
1717: RAISE FND_API.G_EXC_ERROR;
1718: END IF;

Line 1715: FND_MESSAGE.Set_Token('ITEM_COMP',l_item_comp_rec.concatenated_segments);

1711: where item_composition_id = p_Item_Composition_id;
1712:
1713: IF l_count < 1 THEN
1714: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_EMPTY');
1715: FND_MESSAGE.Set_Token('ITEM_COMP',l_item_comp_rec.concatenated_segments);
1716: FND_MSG_PUB.ADD;
1717: RAISE FND_API.G_EXC_ERROR;
1718: END IF;
1719:

Line 1728: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_STAT_NOT_DRFT');

1724: l_item_comp_rec.approval_status_code='APPROVAL_REJECTED'
1725: THEN
1726: l_upd_status := 'APPROVAL_PENDING';
1727: ELSE
1728: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_STAT_NOT_DRFT');
1729: FND_MSG_PUB.ADD;
1730: END IF;
1731: ELSE
1732: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');

Line 1732: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');

1728: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_STAT_NOT_DRFT');
1729: FND_MSG_PUB.ADD;
1730: END IF;
1731: ELSE
1732: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');
1733: FND_MSG_PUB.ADD;
1734: END IF;
1735:
1736: END IF;

Line 1762: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1758: and OBJECT_VERSION_NUMBER=p_object_Version_number;
1759:
1760: IF sql%rowcount=0
1761: THEN
1762: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1763: FND_MSG_PUB.ADD;
1764: RAISE FND_API.G_EXC_ERROR;
1765: END IF;
1766:

Line 1987: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');

1983:
1984: OPEN get_item_comp_det(p_Item_comp_id);
1985: Fetch get_item_comp_det into l_item_comp_det;
1986: IF get_item_comp_det%NOTFOUND THEN
1987: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
1988: FND_MSG_PUB.ADD;
1989: END IF;
1990: close get_item_comp_det;
1991:

Line 1996: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_STAT_NOT_COMP');

1992:
1993: IF l_item_comp_det.approval_status_code <> 'COMPLETE'
1994: OR l_item_comp_det.effective_end_date IS NOT NULL
1995: THEN
1996: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_STAT_NOT_COMP');
1997: FND_MSG_PUB.ADD;
1998: END IF;
1999:
2000:

Line 2003: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1999:
2000:
2001: IF l_item_comp_det.object_version_number <> p_object_version_number
2002: THEN
2003: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2004: FND_MSG_PUB.ADD;
2005: END IF;
2006:
2007:

Line 2011: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_REVISION_EXIST');

2007:
2008: OPEN get_revision_info(p_Item_comp_id);
2009: FETCH get_revision_info INTO l_dummy;
2010: IF get_revision_info%FOUND THEN
2011: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_REVISION_EXIST');
2012: FND_MSG_PUB.ADD;
2013: END IF;
2014: CLOSE get_revision_info;
2015:

Line 2414: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');

2410: OPEN get_item_comp_det(p_Item_comp_id);
2411: FETCH get_item_comp_det INTO l_item_comp_det;
2412: IF get_item_comp_det%NOTFOUND
2413: THEN
2414: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
2415: FND_MSG_PUB.ADD;
2416: END IF;
2417: CLOSE get_item_comp_det;
2418:

Line 2421: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2417: CLOSE get_item_comp_det;
2418:
2419: IF l_item_comp_det.object_version_number <> p_object_version_number
2420: THEN
2421: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2422: FND_MSG_PUB.ADD;
2423: END IF;
2424:
2425: