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_ITEMGROUP_PUB dependencies on FND_MSG_PUB

Line 106: FND_MSG_PUB.Initialize;

102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE
105: IF FND_API.To_Boolean(p_init_msg_list) THEN
106: FND_MSG_PUB.Initialize;
107: END IF;
108:
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 123: FND_MSG_PUB.ADD;

119: IF l_item_group_rec.type_code IS NOT NULL THEN
120: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_TYPE',
121: P_LOOKUP_CODE =>l_item_group_rec.type_code) THEN
122: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_INAVLID');
123: FND_MSG_PUB.ADD;
124: END IF;
125: ELSIF l_item_group_rec.type_meaning IS NOT NULL THEN
126: AHL_UTIL_MC_PKG.CONVERT_TO_LOOKUPCODE(
127: P_LOOKUP_TYPE => 'AHL_ITEMGROUP_TYPE',

Line 133: FND_MSG_PUB.ADD;

129: X_LOOKUP_CODE => l_item_group_rec.type_code,
130: X_RETURN_VAL => l_return_val);
131: IF NOT l_return_val THEN
132: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_INAVLID');
133: FND_MSG_PUB.ADD;
134: END IF;
135: ELSIF l_item_group_rec.OPERATION_FLAG = 'C' THEN
136: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NULL');
137: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);

Line 138: FND_MSG_PUB.ADD;

134: END IF;
135: ELSIF l_item_group_rec.OPERATION_FLAG = 'C' THEN
136: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NULL');
137: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
138: FND_MSG_PUB.ADD;
139: END IF;
140:
141: IF l_item_group_rec.status_code IS NOT NULL THEN
142: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_STATUS',

Line 145: FND_MSG_PUB.ADD;

141: IF l_item_group_rec.status_code IS NOT NULL THEN
142: IF NOT AHL_UTIL_MC_PKG.VALIDATE_LOOKUP_CODE(P_LOOKUP_TYPE => 'AHL_ITEMGROUP_STATUS',
143: P_LOOKUP_CODE =>l_item_group_rec.status_code) THEN
144: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STATUS_INAVLID');
145: FND_MSG_PUB.ADD;
146: END IF;
147: ELSIF l_item_group_rec.status_meaning IS NOT NULL THEN
148: AHL_UTIL_MC_PKG.CONVERT_TO_LOOKUPCODE(
149: P_LOOKUP_TYPE => 'AHL_ITEMGROUP_STATUS',

Line 155: FND_MSG_PUB.ADD;

151: X_LOOKUP_CODE => l_item_group_rec.status_code,
152: X_RETURN_VAL => l_return_val);
153: IF NOT l_return_val THEN
154: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STATUS_INAVLID');
155: FND_MSG_PUB.ADD;
156: END IF;
157: END IF;
158:
159: END IF;

Line 197: FND_MSG_PUB.ADD;

193:
194: IF l_item_group_rec.name IS NULL
195: THEN
196: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NAME_NULL');
197: FND_MSG_PUB.ADD;
198:
199: END IF;
200:
201: IF l_item_group_rec.status_code IS NOT NULL

Line 206: FND_MSG_PUB.ADD;

202: AND l_item_group_rec.status_code <> FND_API.G_MISS_CHAR
203: AND l_item_group_rec.status_code <> 'DRAFT'
204: THEN
205: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_CRE_DRAFT');
206: FND_MSG_PUB.ADD;
207:
208: END IF;
209:
210: IF l_item_group_rec.type_code IS NULL AND

Line 215: FND_MSG_PUB.ADD;

211: l_item_group_rec.TYPE_MEANING IS NULL
212: THEN
213: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NULL');
214: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
215: FND_MSG_PUB.ADD;
216: ELSIF l_item_group_rec.TYPE_MEANING IS NOT NULL THEN
217: AHL_UTIL_MC_PKG.Convert_To_LookupCode('AHL_ITEMGROUP_TYPE',
218: l_item_group_rec.TYPE_MEANING,
219: l_lookup_code,

Line 225: FND_MSG_PUB.ADD;

221: IF (l_return_val) THEN
222: p_x_item_group_rec.type_code := l_lookup_code;
223: ELSE
224: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_INAVLID');
225: FND_MSG_PUB.ADD;
226: END IF;
227:
228: END IF;
229: END IF;

Line 246: FND_MSG_PUB.ADD;

242: IF (ahl_item_group_csr%FOUND) THEN
243: p_x_item_group_rec.item_group_id := l_item_group_id;
244: IF l_type_code <> p_x_item_group_rec.type_code THEN
245: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
246: FND_MSG_PUB.ADD;
247: END IF;
248:
249: ELSE
250: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');

Line 252: FND_MSG_PUB.ADD;

248:
249: ELSE
250: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
251: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
252: FND_MSG_PUB.ADD;
253: END IF;
254:
255: ELSE
256: -- Both ID and name are missing.

Line 258: FND_MSG_PUB.ADD;

254:
255: ELSE
256: -- Both ID and name are missing.
257: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NULL');
258: FND_MSG_PUB.ADD;
259:
260: END IF;
261: ELSIF NVL(p_module_type,'X') <> 'JSP' THEN
262: OPEN Item_grp_name_csr(l_item_group_rec.item_group_id);

Line 269: FND_MSG_PUB.ADD;

265: IF l_item_group_name <> p_x_item_group_rec.name
266: THEN
267: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
268: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
269: FND_MSG_PUB.ADD;
270: END IF;
271: IF l_type_code <> p_x_item_group_rec.type_code THEN
272: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
273: FND_MSG_PUB.ADD;

Line 273: FND_MSG_PUB.ADD;

269: FND_MSG_PUB.ADD;
270: END IF;
271: IF l_type_code <> p_x_item_group_rec.type_code THEN
272: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
273: FND_MSG_PUB.ADD;
274: END IF;
275:
276: ELSE
277: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');

Line 279: FND_MSG_PUB.ADD;

275:
276: ELSE
277: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
278: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
279: FND_MSG_PUB.ADD;
280: END IF;
281:
282: END IF;
283:

Line 305: FND_MSG_PUB.ADD;

301: (p_x_items_tbl(i).item_group_name <> FND_API.G_MISS_CHAR) THEN
302: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
303: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
304: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_name);
305: FND_MSG_PUB.ADD;
306: --dbms_output.put_line('Item Association record does not match Item Group');
307: ELSE
308: -- Both ID and Name are missing.
309: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NULL');

Line 310: FND_MSG_PUB.ADD;

306: --dbms_output.put_line('Item Association record does not match Item Group');
307: ELSE
308: -- Both ID and Name are missing.
309: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NULL');
310: FND_MSG_PUB.ADD;
311: END IF;
312: END IF;
313: END IF;
314:

Line 322: x_msg_count := FND_MSG_PUB.count_msg;

318:
319: END IF;
320:
321: -- Check Error Message stack.
322: x_msg_count := FND_MSG_PUB.count_msg;
323: IF x_msg_count > 0 THEN
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326:

Line 403: FND_MSG_PUB.Count_And_Get

399: COMMIT WORK;
400: END IF;
401:
402: -- Standard call to get message count and if count is 1, get message
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,
405: p_data => x_msg_data,
406: p_encoded => fnd_api.g_false);
407:

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

415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: Rollback to Process_Item_group_Pub;
419: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
420: p_data => x_msg_data,
421: p_encoded => fnd_api.g_false);
422:
423: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

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

429:
430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: Rollback to Process_Item_group_Pub;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false);
436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
437: THEN

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

441:
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: Rollback to Process_Item_group_Pub;
445: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
446: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
447: p_procedure_name => 'Process_Item_group',
448: p_error_text => SQLERRM);
449: END IF;

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

442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: Rollback to Process_Item_group_Pub;
445: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
446: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
447: p_procedure_name => 'Process_Item_group',
448: p_error_text => SQLERRM);
449: END IF;
450: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

446: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
447: p_procedure_name => 'Process_Item_group',
448: p_error_text => SQLERRM);
449: END IF;
450: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
451: p_data => x_msg_data,
452: p_encoded => fnd_api.g_false);
453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
454: THEN

Line 540: FND_MSG_PUB.ADD;

536: l_item_assoc_rec.inventory_org_id := l_inventory_org_id;
537: ELSE
538: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
539: FND_MESSAGE.Set_Token('ORG',l_item_assoc_rec.inventory_org_code);
540: FND_MSG_PUB.ADD;
541: END IF;
542: CLOSE mtl_parameters_csr;
543: ELSIF (l_item_assoc_rec.operation_flag = 'C') THEN
544: -- Both ID and code are missing.

Line 546: FND_MSG_PUB.ADD;

542: CLOSE mtl_parameters_csr;
543: ELSIF (l_item_assoc_rec.operation_flag = 'C') THEN
544: -- Both ID and code are missing.
545: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_NULL');
546: FND_MSG_PUB.ADD;
547: END IF;
548:
549: END IF;
550:

Line 568: FND_MSG_PUB.ADD;

564:
565: ELSE
566: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
567: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.inventory_item_name);
568: FND_MSG_PUB.ADD;
569: END IF;
570: CLOSE mtl_system_items_csr;
571: ELSIF (l_item_assoc_rec.operation_flag = 'C') THEN
572: -- Both ID and name missing.

Line 574: FND_MSG_PUB.ADD;

570: CLOSE mtl_system_items_csr;
571: ELSIF (l_item_assoc_rec.operation_flag = 'C') THEN
572: -- Both ID and name missing.
573: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
574: FND_MSG_PUB.ADD;
575: END IF;
576:
577: ELSE
578: OPEN mtl_segment_csr(l_item_assoc_rec.inventory_item_id,

Line 584: FND_MSG_PUB.ADD;

580: FETCH mtl_segment_csr INTO l_concatenated_segments;
581: IF (mtl_segment_csr%NOTFOUND) THEN
582: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
583: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.inventory_item_id);
584: FND_MSG_PUB.ADD;
585: ELSE
586: l_item_assoc_rec.inventory_item_name := l_concatenated_segments;
587: END IF;
588: CLOSE mtl_segment_csr;

Line 598: FND_MSG_PUB.ADD;

594: l_item_assoc_rec.priority = FND_API.G_MISS_NUM)
595: THEN
596: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_NULL');
597: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.inventory_item_name);
598: FND_MSG_PUB.ADD;
599: ELSIF ( INSTR(l_item_assoc_rec.priority,'.') > 0 )
600: THEN
601: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID_JSP');
602: FND_MSG_PUB.ADD;

Line 602: FND_MSG_PUB.ADD;

598: FND_MSG_PUB.ADD;
599: ELSIF ( INSTR(l_item_assoc_rec.priority,'.') > 0 )
600: THEN
601: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID_JSP');
602: FND_MSG_PUB.ADD;
603: END IF;
604:
605:
606: -- Check if item association id exists; if not populate it.

Line 619: FND_MSG_PUB.ADD;

615: IF (ahl_item_associations_csr%FOUND) THEN
616: l_item_assoc_rec.item_association_id := l_item_association_id;
617: ELSE
618: FND_MESSAGE.Set_Name('AHL','AHL_MC_ASSOC_NULL');
619: FND_MSG_PUB.ADD;
620: END IF;
621: END IF;
622: END IF; /* operation flag */
623:

Line 641: FND_MSG_PUB.ADD;

637: ELSE
638: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_INVALID');
639: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.inventory_item_name);
640: FND_MESSAGE.Set_Token('INTER_CODE',l_item_assoc_rec.Interchange_type_meaning);
641: FND_MSG_PUB.ADD;
642: END IF;
643: ELSE
644: IF (l_item_assoc_rec.Interchange_type_meaning IS NULL) THEN
645: l_item_assoc_rec.interchange_type_code := null;