APPS.AHL_MC_ITEMGROUP_PVT dependencies on FND_MESSAGE

Line 30: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NAME_NULL');

26:
27: BEGIN
28:
29: IF (p_name IS NULL OR p_name = FND_API.G_MISS_CHAR) THEN
30: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_NAME_NULL');
31: FND_MSG_PUB.ADD;
32: RETURN;
33: END IF;
34:

Line 38: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_EXISTS');

34:
35: OPEN Item_group_csr;
36: FETCH Item_group_csr INTO l_junk;
37: IF (Item_group_csr%FOUND) THEN
38: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_EXISTS');
39: FND_MESSAGE.Set_Token('ITEM_GRP',p_name);
40: FND_MSG_PUB.ADD;
41: --dbms_output.put_line('Item Group already exists');
42: END IF;

Line 39: FND_MESSAGE.Set_Token('ITEM_GRP',p_name);

35: OPEN Item_group_csr;
36: FETCH Item_group_csr INTO l_junk;
37: IF (Item_group_csr%FOUND) THEN
38: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_EXISTS');
39: FND_MESSAGE.Set_Token('ITEM_GRP',p_name);
40: FND_MSG_PUB.ADD;
41: --dbms_output.put_line('Item Group already exists');
42: END IF;
43: CLOSE Item_group_csr;

Line 70: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');

66: OPEN check_priority_dup_exists;
67: FETCH check_priority_dup_exists INTO l_priority;
68: IF (check_priority_dup_exists%FOUND)
69: THEN
70: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');
71: FND_MSG_PUB.ADD;
72: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
73: THEN
74: fnd_log.message

Line 111: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REVISION_NON_UNIQUE');

107: OPEN check_revision_dup_exists;
108: FETCH check_revision_dup_exists INTO l_revision;
109: IF (check_revision_dup_exists%FOUND)
110: THEN
111: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REVISION_NON_UNIQUE');
112: FND_MSG_PUB.ADD;
113: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
114: THEN
115: fnd_log.message

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

351: IF (p_inventory_item_id IS NULL)
352: OR (p_inventory_item_id = FND_API.G_MISS_NUM)
353: OR (p_inventory_org_id IS NULL)
354: OR (p_inventory_org_id = FND_API.G_MISS_NUM) THEN
355: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
356: --FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
357: FND_MSG_PUB.ADD;
358: --dbms_output.put_line('Inventory item is null.');
359: RETURN;

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

352: OR (p_inventory_item_id = FND_API.G_MISS_NUM)
353: OR (p_inventory_org_id IS NULL)
354: OR (p_inventory_org_id = FND_API.G_MISS_NUM) THEN
355: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NULL');
356: --FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
357: FND_MSG_PUB.ADD;
358: --dbms_output.put_line('Inventory item is null.');
359: RETURN;
360: END IF;

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

362: -- For organization code
363: OPEN mtl_parameters_csr(p_inventory_org_id);
364: FETCH mtl_parameters_csr INTO l_organization_code,x_master_org_id;
365: IF (mtl_parameters_csr%NOTFOUND) THEN
366: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
367: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
368: FND_MSG_PUB.ADD;
369: --dbms_output.put_line('Organization does not exist');
370: END IF;

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

363: OPEN mtl_parameters_csr(p_inventory_org_id);
364: FETCH mtl_parameters_csr INTO l_organization_code,x_master_org_id;
365: IF (mtl_parameters_csr%NOTFOUND) THEN
366: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
367: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
368: FND_MSG_PUB.ADD;
369: --dbms_output.put_line('Organization does not exist');
370: END IF;
371: CLOSE mtl_parameters_csr;

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

376: l_revision_qty_control_code;
377: l_segment1 := l_segment1 || ',' || l_organization_code;
378:
379: IF (mtl_system_items_csr%NOTFOUND) THEN
380: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
381: FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
382: FND_MSG_PUB.ADD;
383: --dbms_output.put_line('Inventory item does not exist');
384:

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

377: l_segment1 := l_segment1 || ',' || l_organization_code;
378:
379: IF (mtl_system_items_csr%NOTFOUND) THEN
380: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_INVALID');
381: FND_MESSAGE.Set_Token('INV_ITEM',p_inventory_item_id);
382: FND_MSG_PUB.ADD;
383: --dbms_output.put_line('Inventory item does not exist');
384:
385: l_segment1 := null;

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

389: ELSE
390:
391: /*
392: IF ( UPPER(l_instance_track) <> 'Y') THEN
393: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');
394: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
395: FND_MSG_PUB.ADD;
396: --dbms_output.put_line('Inventory item not trackable');
397: END IF;

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

390:
391: /*
392: IF ( UPPER(l_instance_track) <> 'Y') THEN
393: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');
394: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
395: FND_MSG_PUB.ADD;
396: --dbms_output.put_line('Inventory item not trackable');
397: END IF;
398:

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

398:
399: */
400: IF ( UPPER(p_type_code) = 'TRACKED' AND UPPER(l_instance_track) <> 'Y')
401: THEN
402: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');
403: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
404: FND_MSG_PUB.ADD;
405: --dbms_output.put_line('Inventory item not trackable');
406: ELSIF ( UPPER(p_type_code) = 'NON-TRACKED' AND UPPER(l_instance_track) = 'Y')

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

399: */
400: IF ( UPPER(p_type_code) = 'TRACKED' AND UPPER(l_instance_track) <> 'Y')
401: THEN
402: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_TRACK');
403: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
404: FND_MSG_PUB.ADD;
405: --dbms_output.put_line('Inventory item not trackable');
406: ELSIF ( UPPER(p_type_code) = 'NON-TRACKED' AND UPPER(l_instance_track) = 'Y')
407: THEN

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

404: FND_MSG_PUB.ADD;
405: --dbms_output.put_line('Inventory item not trackable');
406: ELSIF ( UPPER(p_type_code) = 'NON-TRACKED' AND UPPER(l_instance_track) = 'Y')
407: THEN
408: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NON_TRACK');
409: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
410: FND_MSG_PUB.ADD;
411: --dbms_output.put_line('Inventory item are trackable');
412: END IF;

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

405: --dbms_output.put_line('Inventory item not trackable');
406: ELSIF ( UPPER(p_type_code) = 'NON-TRACKED' AND UPPER(l_instance_track) = 'Y')
407: THEN
408: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_NON_TRACK');
409: FND_MESSAGE.Set_Token('INV_ITEM',l_segment1);
410: FND_MSG_PUB.ADD;
411: --dbms_output.put_line('Inventory item are trackable');
412: END IF;
413:

Line 433: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_TYP_NULL');

429:
430: BEGIN
431: IF (p_interchange_type_code IS NULL
432: OR p_interchange_type_code = FND_API.G_MISS_CHAR) THEN
433: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_TYP_NULL');
434: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
435: FND_MSG_PUB.ADD;
436: RETURN;
437: END IF;

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

430: BEGIN
431: IF (p_interchange_type_code IS NULL
432: OR p_interchange_type_code = FND_API.G_MISS_CHAR) THEN
433: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_TYP_NULL');
434: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
435: FND_MSG_PUB.ADD;
436: RETURN;
437: END IF;
438:

Line 441: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_INVALID');

437: END IF;
438:
439: IF NOT(AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_INTERCHANGE_ITEM_TYPE', p_interchange_type_code))
440: OR p_interchange_type_code = 'REMOVED' THEN
441: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_INVALID');
442: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
443: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);
444: FND_MSG_PUB.ADD;
445: --dbms_output.put_line('Interchange type code is invalid');

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

438:
439: IF NOT(AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_INTERCHANGE_ITEM_TYPE', p_interchange_type_code))
440: OR p_interchange_type_code = 'REMOVED' THEN
441: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_INVALID');
442: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
443: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);
444: FND_MSG_PUB.ADD;
445: --dbms_output.put_line('Interchange type code is invalid');
446: END IF;

Line 443: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);

439: IF NOT(AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_INTERCHANGE_ITEM_TYPE', p_interchange_type_code))
440: OR p_interchange_type_code = 'REMOVED' THEN
441: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_INVALID');
442: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
443: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);
444: FND_MSG_PUB.ADD;
445: --dbms_output.put_line('Interchange type code is invalid');
446: END IF;
447:

Line 451: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_REASON_NULL');

447:
448: IF p_interchange_type_code = '1-WAY INTERCHANGEABLE'
449: AND TRIM(p_interchange_reason) IS NULL
450: THEN
451: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_REASON_NULL');
452: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);
453: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
454: FND_MSG_PUB.ADD;
455: --dbms_output.put_line('Interchange Reason is Null');

Line 452: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);

448: IF p_interchange_type_code = '1-WAY INTERCHANGEABLE'
449: AND TRIM(p_interchange_reason) IS NULL
450: THEN
451: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_REASON_NULL');
452: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);
453: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
454: FND_MSG_PUB.ADD;
455: --dbms_output.put_line('Interchange Reason is Null');
456: END IF;

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

449: AND TRIM(p_interchange_reason) IS NULL
450: THEN
451: FND_MESSAGE.Set_Name('AHL','AHL_MC_INTER_REASON_NULL');
452: FND_MESSAGE.Set_Token('INTER_CODE',p_interchange_type_code);
453: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
454: FND_MSG_PUB.ADD;
455: --dbms_output.put_line('Interchange Reason is Null');
456: END IF;
457:

Line 485: FND_MESSAGE.Set_Name('AHL','AHL_UC_REV_NOTNULL');

481: RETURN;
482: END IF;
483:
484: IF (nvl(p_revision_qty_control_code,0) <> 2) THEN
485: FND_MESSAGE.Set_Name('AHL','AHL_UC_REV_NOTNULL');
486: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
487: FND_MSG_PUB.ADD;
488: --dbms_output.put_line('Revision is not null. Revision not required.');
489: ELSE

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

482: END IF;
483:
484: IF (nvl(p_revision_qty_control_code,0) <> 2) THEN
485: FND_MESSAGE.Set_Name('AHL','AHL_UC_REV_NOTNULL');
486: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
487: FND_MSG_PUB.ADD;
488: --dbms_output.put_line('Revision is not null. Revision not required.');
489: ELSE
490: OPEN mtl_item_revisions_csr(p_revision,p_inventory_id, p_organization_id);

Line 493: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVREVI_INVALID');

489: ELSE
490: OPEN mtl_item_revisions_csr(p_revision,p_inventory_id, p_organization_id);
491: FETCH mtl_item_revisions_csr INTO l_junk;
492: IF (mtl_item_revisions_csr%NOTFOUND) THEN
493: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVREVI_INVALID');
494: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
495: FND_MESSAGE.Set_Token('REVISION',p_revision);
496: FND_MSG_PUB.ADD;
497: --dbms_output.put_line('Revision does not exist');

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

490: OPEN mtl_item_revisions_csr(p_revision,p_inventory_id, p_organization_id);
491: FETCH mtl_item_revisions_csr INTO l_junk;
492: IF (mtl_item_revisions_csr%NOTFOUND) THEN
493: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVREVI_INVALID');
494: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
495: FND_MESSAGE.Set_Token('REVISION',p_revision);
496: FND_MSG_PUB.ADD;
497: --dbms_output.put_line('Revision does not exist');
498: END IF;

Line 495: FND_MESSAGE.Set_Token('REVISION',p_revision);

491: FETCH mtl_item_revisions_csr INTO l_junk;
492: IF (mtl_item_revisions_csr%NOTFOUND) THEN
493: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVREVI_INVALID');
494: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
495: FND_MESSAGE.Set_Token('REVISION',p_revision);
496: FND_MSG_PUB.ADD;
497: --dbms_output.put_line('Revision does not exist');
498: END IF;
499:

Line 569: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');

565: OPEN item_revnotnull_csr(p_item_group_id, p_inventory_item_id, p_inventory_org_id);
566: FETCH item_revnotnull_csr INTO l_junk;
567: IF (item_revnotnull_csr%FOUND) THEN
568: if l_junk is not null then
569: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
570: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
571: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
573: FND_MSG_PUB.ADD;

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

566: FETCH item_revnotnull_csr INTO l_junk;
567: IF (item_revnotnull_csr%FOUND) THEN
568: if l_junk is not null then
569: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
570: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
571: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
573: FND_MSG_PUB.ADD;
574: ELSE

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

567: IF (item_revnotnull_csr%FOUND) THEN
568: if l_junk is not null then
569: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
570: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
571: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
573: FND_MSG_PUB.ADD;
574: ELSE
575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');

Line 572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

568: if l_junk is not null then
569: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
570: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
571: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
573: FND_MSG_PUB.ADD;
574: ELSE
575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
576: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);

Line 575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');

571: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
573: FND_MSG_PUB.ADD;
574: ELSE
575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
576: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
577: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
578: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
579: FND_MSG_PUB.ADD;

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

572: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
573: FND_MSG_PUB.ADD;
574: ELSE
575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
576: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
577: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
578: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
579: FND_MSG_PUB.ADD;
580: END IF;

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

573: FND_MSG_PUB.ADD;
574: ELSE
575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
576: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
577: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
578: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
579: FND_MSG_PUB.ADD;
580: END IF;
581: END IF;

Line 578: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

574: ELSE
575: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
576: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
577: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
578: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
579: FND_MSG_PUB.ADD;
580: END IF;
581: END IF;
582: CLOSE item_revnotnull_csr;

Line 587: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');

583: ELSE
584: OPEN item_revnull_csr(p_item_group_id, p_inventory_item_id,p_item_revision,p_inventory_org_id);
585: FETCH item_revnull_csr INTO l_junk;
586: IF (item_revnull_csr%FOUND) THEN
587: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
588: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
589: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
590: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
591: FND_MSG_PUB.ADD;

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

584: OPEN item_revnull_csr(p_item_group_id, p_inventory_item_id,p_item_revision,p_inventory_org_id);
585: FETCH item_revnull_csr INTO l_junk;
586: IF (item_revnull_csr%FOUND) THEN
587: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
588: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
589: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
590: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
591: FND_MSG_PUB.ADD;
592: CLOSE item_revnull_csr;

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

585: FETCH item_revnull_csr INTO l_junk;
586: IF (item_revnull_csr%FOUND) THEN
587: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
588: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
589: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
590: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
591: FND_MSG_PUB.ADD;
592: CLOSE item_revnull_csr;
593: ELSE

Line 590: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

586: IF (item_revnull_csr%FOUND) THEN
587: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_REV_EXISTS');
588: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
589: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
590: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
591: FND_MSG_PUB.ADD;
592: CLOSE item_revnull_csr;
593: ELSE
594: OPEN rev_exists_csr(p_item_group_id,p_inventory_item_id,p_inventory_org_id,p_item_revision);

Line 597: FND_MESSAGE.Set_Name('AHL','AHL_MC_SAME_REV_EXISTS');

593: ELSE
594: OPEN rev_exists_csr(p_item_group_id,p_inventory_item_id,p_inventory_org_id,p_item_revision);
595: FETCH rev_exists_csr INTO l_junk;
596: IF (rev_exists_csr%FOUND) THEN
597: FND_MESSAGE.Set_Name('AHL','AHL_MC_SAME_REV_EXISTS');
598: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
599: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
600: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
601: FND_MSG_PUB.ADD;

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

594: OPEN rev_exists_csr(p_item_group_id,p_inventory_item_id,p_inventory_org_id,p_item_revision);
595: FETCH rev_exists_csr INTO l_junk;
596: IF (rev_exists_csr%FOUND) THEN
597: FND_MESSAGE.Set_Name('AHL','AHL_MC_SAME_REV_EXISTS');
598: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
599: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
600: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
601: FND_MSG_PUB.ADD;
602: END IF;

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

595: FETCH rev_exists_csr INTO l_junk;
596: IF (rev_exists_csr%FOUND) THEN
597: FND_MESSAGE.Set_Name('AHL','AHL_MC_SAME_REV_EXISTS');
598: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
599: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
600: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
601: FND_MSG_PUB.ADD;
602: END IF;
603: CLOSE rev_exists_csr;

Line 600: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

596: IF (rev_exists_csr%FOUND) THEN
597: FND_MESSAGE.Set_Name('AHL','AHL_MC_SAME_REV_EXISTS');
598: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
599: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
600: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
601: FND_MSG_PUB.ADD;
602: END IF;
603: CLOSE rev_exists_csr;
604: END IF;

Line 628: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');

624: AND inventory_item_id = p_inventory_item_id;
625:
626: EXCEPTION
627: WHEN TOO_MANY_ROWS THEN
628: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
629: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
630: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
631: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
632: FND_MSG_PUB.ADD;

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

625:
626: EXCEPTION
627: WHEN TOO_MANY_ROWS THEN
628: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
629: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
630: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
631: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
632: FND_MSG_PUB.ADD;
633: WHEN NO_DATA_FOUND THEN

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

626: EXCEPTION
627: WHEN TOO_MANY_ROWS THEN
628: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
629: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
630: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
631: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
632: FND_MSG_PUB.ADD;
633: WHEN NO_DATA_FOUND THEN
634: NULL;

Line 631: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

627: WHEN TOO_MANY_ROWS THEN
628: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOTNULL_REV_EXISTS');
629: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
630: FND_MESSAGE.Set_Token('ORG',p_inventory_org_id);
631: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
632: FND_MSG_PUB.ADD;
633: WHEN NO_DATA_FOUND THEN
634: NULL;
635: WHEN OTHERS THEN

Line 650: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_OR_SAME_REV_EXISTS');

646: p_item_revision);
647:
648: FETCH rev_exists_csr INTO l_junk;
649: IF (rev_exists_csr%FOUND) THEN
650: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_OR_SAME_REV_EXISTS');
651: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
652: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
653: FND_MSG_PUB.ADD;
654: END IF;

Line 651: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

647:
648: FETCH rev_exists_csr INTO l_junk;
649: IF (rev_exists_csr%FOUND) THEN
650: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_OR_SAME_REV_EXISTS');
651: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
652: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
653: FND_MSG_PUB.ADD;
654: END IF;
655: CLOSE rev_exists_csr;*/

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

648: FETCH rev_exists_csr INTO l_junk;
649: IF (rev_exists_csr%FOUND) THEN
650: FND_MESSAGE.Set_Name('AHL','AHL_MC_NULL_OR_SAME_REV_EXISTS');
651: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
652: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
653: FND_MSG_PUB.ADD;
654: END IF;
655: CLOSE rev_exists_csr;*/
656: END IF;

Line 686: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');

682: IF (p_item_revision = FND_API.G_MISS_CHAR OR p_item_revision IS NULL) THEN
683: OPEN item_assoc_csr(p_item_group_id, p_inventory_item_id,'000', p_inventory_org_id);
684: FETCH item_assoc_csr INTO l_junk;
685: IF (item_assoc_csr%FOUND) THEN
686: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');
687: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
688: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
689: FND_MSG_PUB.ADD;
690: END IF;

Line 687: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

683: OPEN item_assoc_csr(p_item_group_id, p_inventory_item_id,'000', p_inventory_org_id);
684: FETCH item_assoc_csr INTO l_junk;
685: IF (item_assoc_csr%FOUND) THEN
686: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');
687: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
688: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
689: FND_MSG_PUB.ADD;
690: END IF;
691: CLOSE item_assoc_csr;

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

684: FETCH item_assoc_csr INTO l_junk;
685: IF (item_assoc_csr%FOUND) THEN
686: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');
687: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
688: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
689: FND_MSG_PUB.ADD;
690: END IF;
691: CLOSE item_assoc_csr;
692: ELSE

Line 696: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');

692: ELSE
693: OPEN item_assoc_csr(p_item_group_id, p_inventory_item_id,p_item_revision,p_inventory_org_id);
694: FETCH item_assoc_csr INTO l_junk;
695: IF (item_assoc_csr%FOUND) THEN
696: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');
697: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
698: FND_MESSAGE.Set_Token('INV_ITEM',p_item_revision || ',' || p_inv_segment );
699: FND_MSG_PUB.ADD;
700: END IF;

Line 697: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

693: OPEN item_assoc_csr(p_item_group_id, p_inventory_item_id,p_item_revision,p_inventory_org_id);
694: FETCH item_assoc_csr INTO l_junk;
695: IF (item_assoc_csr%FOUND) THEN
696: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');
697: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
698: FND_MESSAGE.Set_Token('INV_ITEM',p_item_revision || ',' || p_inv_segment );
699: FND_MSG_PUB.ADD;
700: END IF;
701: CLOSE item_assoc_csr;

Line 698: FND_MESSAGE.Set_Token('INV_ITEM',p_item_revision || ',' || p_inv_segment );

694: FETCH item_assoc_csr INTO l_junk;
695: IF (item_assoc_csr%FOUND) THEN
696: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');
697: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
698: FND_MESSAGE.Set_Token('INV_ITEM',p_item_revision || ',' || p_inv_segment );
699: FND_MSG_PUB.ADD;
700: END IF;
701: CLOSE item_assoc_csr;
702: END IF;

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

719:
720: -- Check if UOM entered and valid.
721: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
722: -- uom_code is null but quantity is not null.
723: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');
724: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
725: FND_MSG_PUB.ADD;
726: --dbms_output.put_line('Uom is null');
727: ELSIF NOT(inv_convert.Validate_Item_Uom(p_item_id => p_inventory_item_id,

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

720: -- Check if UOM entered and valid.
721: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
722: -- uom_code is null but quantity is not null.
723: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_NULL');
724: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
725: FND_MSG_PUB.ADD;
726: --dbms_output.put_line('Uom is null');
727: ELSIF NOT(inv_convert.Validate_Item_Uom(p_item_id => p_inventory_item_id,
728: p_organization_id => p_inventory_org_id,

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

727: ELSIF NOT(inv_convert.Validate_Item_Uom(p_item_id => p_inventory_item_id,
728: p_organization_id => p_inventory_org_id,
729: p_uom_code => p_uom_code))
730: THEN
731: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');
732: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
733: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
734: FND_MSG_PUB.ADD;
735: --dbms_output.put_line('Invalid UOM code for the item');

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

728: p_organization_id => p_inventory_org_id,
729: p_uom_code => p_uom_code))
730: THEN
731: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');
732: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
733: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
734: FND_MSG_PUB.ADD;
735: --dbms_output.put_line('Invalid UOM code for the item');
736: END IF;

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

729: p_uom_code => p_uom_code))
730: THEN
731: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVUOM_INVALID');
732: FND_MESSAGE.Set_Token('UOM_CODE',p_uom_code);
733: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
734: FND_MSG_PUB.ADD;
735: --dbms_output.put_line('Invalid UOM code for the item');
736: END IF;
737:

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

736: END IF;
737:
738: -- Validate quantity.
739: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
740: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
741: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
742: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
743: FND_MSG_PUB.ADD;
744: --dbms_output.put_line('Quantity is null');

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

737:
738: -- Validate quantity.
739: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
740: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
741: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
742: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
743: FND_MSG_PUB.ADD;
744: --dbms_output.put_line('Quantity is null');
745: ELSIF (p_quantity < 0) THEN

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

738: -- Validate quantity.
739: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
740: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
741: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
742: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
743: FND_MSG_PUB.ADD;
744: --dbms_output.put_line('Quantity is null');
745: ELSIF (p_quantity < 0) THEN
746: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');

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

742: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
743: FND_MSG_PUB.ADD;
744: --dbms_output.put_line('Quantity is null');
745: ELSIF (p_quantity < 0) THEN
746: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
747: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
748: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
749: FND_MSG_PUB.ADD;
750: --dbms_output.put_line('Invalid quantity');

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

743: FND_MSG_PUB.ADD;
744: --dbms_output.put_line('Quantity is null');
745: ELSIF (p_quantity < 0) THEN
746: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
747: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
748: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
749: FND_MSG_PUB.ADD;
750: --dbms_output.put_line('Invalid quantity');
751: END IF;

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

744: --dbms_output.put_line('Quantity is null');
745: ELSIF (p_quantity < 0) THEN
746: FND_MESSAGE.Set_Name('AHL','AHL_MC_INVQTY_INVALID');
747: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
748: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
749: FND_MSG_PUB.ADD;
750: --dbms_output.put_line('Invalid quantity');
751: END IF;
752:

Line 833: FND_MESSAGE.Set_Name('AHL','AHL_MC_PARTASSOC_EXISTS');

829: p_inventory_item_id,
830: p_inventory_org_id);
831: FETCH chk_top_node_csr INTO l_junk;
832: IF (chk_top_node_csr%FOUND) THEN
833: FND_MESSAGE.Set_Name('AHL','AHL_MC_PARTASSOC_EXISTS');
834: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
835: FND_MSG_PUB.ADD;
836: l_unit_found := TRUE;
837: END IF;

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

830: p_inventory_org_id);
831: FETCH chk_top_node_csr INTO l_junk;
832: IF (chk_top_node_csr%FOUND) THEN
833: FND_MESSAGE.Set_Name('AHL','AHL_MC_PARTASSOC_EXISTS');
834: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
835: FND_MSG_PUB.ADD;
836: l_unit_found := TRUE;
837: END IF;
838: CLOSE chk_top_node_csr;

Line 848: FND_MESSAGE.Set_Name('AHL','AHL_MC_PARTASSOC_EXISTS');

844: p_inventory_org_id)
845: LOOP
846: l_unitname := AHL_UMP_UTIL_PKG.Get_UnitName(item_instance_rec.csi_item_instance_id);
847: IF (l_unitname IS NOT NULL) THEN
848: FND_MESSAGE.Set_Name('AHL','AHL_MC_PARTASSOC_EXISTS');
849: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
850: FND_MSG_PUB.ADD;
851: l_unit_found := TRUE;
852: EXIT; -- exit instance loop.

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

845: LOOP
846: l_unitname := AHL_UMP_UTIL_PKG.Get_UnitName(item_instance_rec.csi_item_instance_id);
847: IF (l_unitname IS NOT NULL) THEN
848: FND_MESSAGE.Set_Name('AHL','AHL_MC_PARTASSOC_EXISTS');
849: FND_MESSAGE.Set_Token('INV_ITEM',p_inv_segment);
850: FND_MSG_PUB.ADD;
851: l_unit_found := TRUE;
852: EXIT; -- exit instance loop.
853: END IF;

Line 923: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');

919: OPEN Item_assoc_csr(l_x_item_assoc_rec.item_association_id);
920: FETCH Item_assoc_csr INTO l_item_assoc_rec;
921: IF (Item_assoc_csr%NOTFOUND) THEN
922: CLOSE Item_assoc_csr;
923: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');
924: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.concatenated_segments);
925: FND_MSG_PUB.ADD;
926: --dbms_output.put_line('Item Assoc does not exist');
927: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 924: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.concatenated_segments);

920: FETCH Item_assoc_csr INTO l_item_assoc_rec;
921: IF (Item_assoc_csr%NOTFOUND) THEN
922: CLOSE Item_assoc_csr;
923: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');
924: FND_MESSAGE.Set_Token('INV_ITEM',l_item_assoc_rec.concatenated_segments);
925: FND_MSG_PUB.ADD;
926: --dbms_output.put_line('Item Assoc does not exist');
927: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;

Line 955: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');

951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
952: 'ahl_mc_itemgroup_pvt.Validate_Item_Assoc', l_item_key);
953: END IF;
954:
955: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
956: FND_MSG_PUB.ADD;
957: --dbms_output.put_line('Primary key cannot be updated');
958: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;

Line 1027: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');

1023:
1024: IF (p_x_inventory_list.EXISTS(l_item_key)) THEN
1025: -- if two lines without Revision are the same, show the old Error Message
1026: IF (l_inventory_item_revision = '000') THEN
1027: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');
1028: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
1029: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1030: FND_MSG_PUB.ADD;
1031: --dbms_output.put_line('Item already exists in the list');

Line 1028: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

1024: IF (p_x_inventory_list.EXISTS(l_item_key)) THEN
1025: -- if two lines without Revision are the same, show the old Error Message
1026: IF (l_inventory_item_revision = '000') THEN
1027: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');
1028: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
1029: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1030: FND_MSG_PUB.ADD;
1031: --dbms_output.put_line('Item already exists in the list');
1032: ELSE

Line 1029: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

1025: -- if two lines without Revision are the same, show the old Error Message
1026: IF (l_inventory_item_revision = '000') THEN
1027: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_DUP');
1028: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
1029: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1030: FND_MSG_PUB.ADD;
1031: --dbms_output.put_line('Item already exists in the list');
1032: ELSE
1033: -- if two lines have the same Revision, show new error message with Revision

Line 1034: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');

1030: FND_MSG_PUB.ADD;
1031: --dbms_output.put_line('Item already exists in the list');
1032: ELSE
1033: -- if two lines have the same Revision, show new error message with Revision
1034: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');
1035: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
1036: FND_MESSAGE.Set_Token('INV_ITEM',l_inventory_item_revision || ',' || l_inv_segment);
1037: FND_MSG_PUB.ADD;
1038: END IF;

Line 1035: FND_MESSAGE.Set_Token('GRP_NAME',p_name);

1031: --dbms_output.put_line('Item already exists in the list');
1032: ELSE
1033: -- if two lines have the same Revision, show new error message with Revision
1034: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');
1035: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
1036: FND_MESSAGE.Set_Token('INV_ITEM',l_inventory_item_revision || ',' || l_inv_segment);
1037: FND_MSG_PUB.ADD;
1038: END IF;
1039: ELSE

Line 1036: FND_MESSAGE.Set_Token('INV_ITEM',l_inventory_item_revision || ',' || l_inv_segment);

1032: ELSE
1033: -- if two lines have the same Revision, show new error message with Revision
1034: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_ASSOC_REV_DUP');
1035: FND_MESSAGE.Set_Token('GRP_NAME',p_name);
1036: FND_MESSAGE.Set_Token('INV_ITEM',l_inventory_item_revision || ',' || l_inv_segment);
1037: FND_MSG_PUB.ADD;
1038: END IF;
1039: ELSE
1040: -- match not found, so add to the associative array p_x_inventory_list.

Line 1084: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_1WAY_MISSING_REASON');

1080: --Interchange Reason can not be null for 1-way interchanges
1081: IF (l_x_item_assoc_rec.INTERCHANGE_TYPE_CODE IS NOT NULL AND
1082: l_x_item_assoc_rec.INTERCHANGE_TYPE_CODE = G_FND_1WAY_CODE AND
1083: l_x_item_assoc_rec.INTERCHANGE_REASON IS NULL) THEN
1084: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_1WAY_MISSING_REASON');
1085: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1086: FND_MSG_PUB.ADD;
1087: END IF;
1088: END IF;

Line 1085: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

1081: IF (l_x_item_assoc_rec.INTERCHANGE_TYPE_CODE IS NOT NULL AND
1082: l_x_item_assoc_rec.INTERCHANGE_TYPE_CODE = G_FND_1WAY_CODE AND
1083: l_x_item_assoc_rec.INTERCHANGE_REASON IS NULL) THEN
1084: FND_MESSAGE.Set_Name('AHL','AHL_MC_INV_1WAY_MISSING_REASON');
1085: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1086: FND_MSG_PUB.ADD;
1087: END IF;
1088: END IF;
1089:

Line 1095: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID');

1091: -- Validate priority only for 'Create' and if changed during modify.
1092: IF (l_x_item_assoc_rec.priority <> FND_API.G_MISS_NUM AND l_x_item_assoc_rec.priority IS NOT NULL)
1093: THEN
1094: IF (l_x_item_assoc_rec.priority <= 0) THEN
1095: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID');
1096: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1097: FND_MESSAGE.Set_Token('PRIORITY',l_x_item_assoc_rec.priority);
1098: FND_MSG_PUB.ADD;
1099: --dbms_output.put_line('Invalid priority');

Line 1096: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

1092: IF (l_x_item_assoc_rec.priority <> FND_API.G_MISS_NUM AND l_x_item_assoc_rec.priority IS NOT NULL)
1093: THEN
1094: IF (l_x_item_assoc_rec.priority <= 0) THEN
1095: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID');
1096: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1097: FND_MESSAGE.Set_Token('PRIORITY',l_x_item_assoc_rec.priority);
1098: FND_MSG_PUB.ADD;
1099: --dbms_output.put_line('Invalid priority');
1100: END IF;

Line 1097: FND_MESSAGE.Set_Token('PRIORITY',l_x_item_assoc_rec.priority);

1093: THEN
1094: IF (l_x_item_assoc_rec.priority <= 0) THEN
1095: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_INVALID');
1096: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1097: FND_MESSAGE.Set_Token('PRIORITY',l_x_item_assoc_rec.priority);
1098: FND_MSG_PUB.ADD;
1099: --dbms_output.put_line('Invalid priority');
1100: END IF;
1101: ELSIF l_x_item_assoc_rec.operation_flag = 'C' OR

Line 1103: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_NULL');

1099: --dbms_output.put_line('Invalid priority');
1100: END IF;
1101: ELSIF l_x_item_assoc_rec.operation_flag = 'C' OR
1102: (l_x_item_assoc_rec.operation_flag = 'M' AND l_x_item_assoc_rec.priority = FND_API.G_MISS_NUM) THEN
1103: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_NULL');
1104: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1105: FND_MSG_PUB.ADD;
1106: --dbms_output.put_line('Null priority');
1107: END IF;

Line 1104: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

1100: END IF;
1101: ELSIF l_x_item_assoc_rec.operation_flag = 'C' OR
1102: (l_x_item_assoc_rec.operation_flag = 'M' AND l_x_item_assoc_rec.priority = FND_API.G_MISS_NUM) THEN
1103: FND_MESSAGE.Set_Name('AHL','AHL_MC_PRIORITY_NULL');
1104: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1105: FND_MSG_PUB.ADD;
1106: --dbms_output.put_line('Null priority');
1107: END IF;
1108:

Line 1157: FND_MESSAGE.Set_Name('AHL','AHL_MC_SRLQTY_NULL');

1153: IF (nvl(l_serial_number_control,0) IN (2,5,6)) THEN
1154: IF (l_quantity IS NULL OR
1155: l_quantity = 0 OR
1156: l_quantity = FND_API.G_MISS_NUM) THEN
1157: FND_MESSAGE.Set_Name('AHL','AHL_MC_SRLQTY_NULL');
1158: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1159: FND_MSG_PUB.ADD;
1160: --dbms_output.put_line('Invalid UOM code for the item');
1161: ELSE

Line 1158: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

1154: IF (l_quantity IS NULL OR
1155: l_quantity = 0 OR
1156: l_quantity = FND_API.G_MISS_NUM) THEN
1157: FND_MESSAGE.Set_Name('AHL','AHL_MC_SRLQTY_NULL');
1158: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1159: FND_MSG_PUB.ADD;
1160: --dbms_output.put_line('Invalid UOM code for the item');
1161: ELSE
1162: IF (l_quantity <> 1) THEN

Line 1163: FND_MESSAGE.Set_Name('AHL','AHL_UC_SRLQTY_MISMATCH');

1159: FND_MSG_PUB.ADD;
1160: --dbms_output.put_line('Invalid UOM code for the item');
1161: ELSE
1162: IF (l_quantity <> 1) THEN
1163: FND_MESSAGE.Set_Name('AHL','AHL_UC_SRLQTY_MISMATCH');
1164: FND_MESSAGE.Set_Token('QTY',l_quantity);
1165: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1166: FND_MSG_PUB.ADD;
1167: --dbms_output.put_line('For serialized items Quantity must be 1');

Line 1164: FND_MESSAGE.Set_Token('QTY',l_quantity);

1160: --dbms_output.put_line('Invalid UOM code for the item');
1161: ELSE
1162: IF (l_quantity <> 1) THEN
1163: FND_MESSAGE.Set_Name('AHL','AHL_UC_SRLQTY_MISMATCH');
1164: FND_MESSAGE.Set_Token('QTY',l_quantity);
1165: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1166: FND_MSG_PUB.ADD;
1167: --dbms_output.put_line('For serialized items Quantity must be 1');
1168: END IF;

Line 1165: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);

1161: ELSE
1162: IF (l_quantity <> 1) THEN
1163: FND_MESSAGE.Set_Name('AHL','AHL_UC_SRLQTY_MISMATCH');
1164: FND_MESSAGE.Set_Token('QTY',l_quantity);
1165: FND_MESSAGE.Set_Token('INV_ITEM',l_inv_segment);
1166: FND_MSG_PUB.ADD;
1167: --dbms_output.put_line('For serialized items Quantity must be 1');
1168: END IF;
1169: END IF;

Line 1485: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1481: OPEN Item_assoc_csr(p_row_id);
1482: FETCH Item_assoc_csr INTO l_old_item_assoc_rec;
1483: IF (Item_assoc_csr%NOTFOUND) THEN
1484: CLOSE Item_assoc_csr;
1485: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1486: FND_MSG_PUB.ADD;
1487: --dbms_output.put_line('Item Assoc does not exist');
1488: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1489: END IF;

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

1490:
1491: -- Check Object version number.
1492: IF (l_old_item_assoc_rec.object_version_number <> l_item_assoc_rec.object_version_number) THEN
1493: CLOSE Item_assoc_csr;
1494: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1495: FND_MSG_PUB.ADD;
1496: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1497: END IF;
1498:

Line 1696: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1692: OPEN Item_assoc_csr(p_row_id);
1693: FETCH Item_assoc_csr INTO l_object_version_number;
1694: IF (Item_assoc_csr%NOTFOUND) THEN
1695: CLOSE Item_assoc_csr;
1696: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1697: FND_MSG_PUB.ADD;
1698: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1699: END IF;
1700:

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

1700:
1701: -- Check Object version number.
1702: IF (l_object_version_number <> p_item_assoc_rec.object_version_number) THEN
1703: CLOSE Item_assoc_csr;
1704: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1705: FND_MSG_PUB.ADD;
1706: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1707: END IF;
1708:

Line 2040: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOT_EXISTS');

2036: OPEN Item_group_csr(p_item_group_rec.item_group_id);
2037: FETCH Item_group_csr INTO l_old_item_group_rec;
2038: IF (Item_group_csr%NOTFOUND) THEN
2039: CLOSE Item_group_csr;
2040: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOT_EXISTS');
2041: FND_MSG_PUB.ADD;
2042: --dbms_output.put_line('Item Group does not exist');
2043: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2044: END IF;

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

2045:
2046: -- Check Object version number.
2047: IF (l_old_item_group_rec.object_version_number <> NVL(p_item_group_rec.object_version_number,0)) THEN
2048: CLOSE Item_group_csr;
2049: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2050: FND_MSG_PUB.ADD;
2051: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2052: END IF;
2053:

Line 2070: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');

2066: -- TAMAL -- IG Amendments --
2067: ELSIF (l_old_item_group_rec.name <> p_item_group_rec.name )
2068: THEN
2069: CLOSE Item_group_csr;
2070: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
2071: FND_MSG_PUB.ADD;
2072: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2073: END IF;
2074:

Line 2078: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOUPDATE');

2074:
2075: IF l_old_item_group_rec.status_code in ('COMPLETE','APPROVAL_PENDING')
2076: THEN
2077: CLOSE Item_group_csr;
2078: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOUPDATE');
2079: FND_MESSAGE.Set_Token('STATUS',p_item_group_rec.status_code);
2080: FND_MSG_PUB.ADD;
2081: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2082: --dbms_output.put_line('Item Group cannot be updated if status is Complete or Approval Rejected');

Line 2079: FND_MESSAGE.Set_Token('STATUS',p_item_group_rec.status_code);

2075: IF l_old_item_group_rec.status_code in ('COMPLETE','APPROVAL_PENDING')
2076: THEN
2077: CLOSE Item_group_csr;
2078: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOUPDATE');
2079: FND_MESSAGE.Set_Token('STATUS',p_item_group_rec.status_code);
2080: FND_MSG_PUB.ADD;
2081: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2082: --dbms_output.put_line('Item Group cannot be updated if status is Complete or Approval Rejected');
2083: END IF;

Line 2089: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STAT_NOUPDATE');

2085: IF (p_item_group_rec.status_code <> FND_API.G_MISS_CHAR) THEN
2086:
2087: IF (p_item_group_rec.status_code <> l_old_item_group_rec.status_code)
2088: THEN
2089: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_STAT_NOUPDATE');
2090: FND_MSG_PUB.ADD;
2091: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2092: --dbms_output.put_line('Item Group Status cannot be updated');
2093: END IF;

Line 2099: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');

2095:
2096: IF (p_item_group_rec.type_code <> FND_API.G_MISS_CHAR) THEN
2097: IF (p_item_group_rec.type_code <> l_old_item_group_rec.type_code)
2098: THEN
2099: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
2100: FND_MSG_PUB.ADD;
2101: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2102: --dbms_output.put_line('Item Group Type cannot be updated');
2103: END IF;

Line 2120: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');

2116:
2117: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
2118: -- Check if association record belongs to the item group.
2119: IF (p_x_items_tbl(i).item_group_id <> p_item_group_rec.item_group_id) THEN
2120: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
2121: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2122: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2123: FND_MSG_PUB.ADD;
2124: --dbms_output.put_line('Item Association record does not match Item Group');

Line 2121: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);

2117: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
2118: -- Check if association record belongs to the item group.
2119: IF (p_x_items_tbl(i).item_group_id <> p_item_group_rec.item_group_id) THEN
2120: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
2121: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2122: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2123: FND_MSG_PUB.ADD;
2124: --dbms_output.put_line('Item Association record does not match Item Group');
2125: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2122: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);

2118: -- Check if association record belongs to the item group.
2119: IF (p_x_items_tbl(i).item_group_id <> p_item_group_rec.item_group_id) THEN
2120: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
2121: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2122: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2123: FND_MSG_PUB.ADD;
2124: --dbms_output.put_line('Item Association record does not match Item Group');
2125: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;

Line 2587: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');

2583: OPEN Item_group_csr(p_item_group_rec.item_group_id);
2584: FETCH Item_group_csr INTO l_item_group_rec;
2585: IF (Item_group_csr%NOTFOUND) THEN
2586: CLOSE Item_group_csr;
2587: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
2588: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2589: FND_MSG_PUB.ADD;
2590: --dbms_output.put_line('Item Group does not exist');
2591: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2588: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);

2584: FETCH Item_group_csr INTO l_item_group_rec;
2585: IF (Item_group_csr%NOTFOUND) THEN
2586: CLOSE Item_group_csr;
2587: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
2588: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2589: FND_MSG_PUB.ADD;
2590: --dbms_output.put_line('Item Group does not exist');
2591: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2592: END IF;

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

2593:
2594: -- Check Object version number.
2595: IF (l_item_group_rec.object_version_number <> p_item_group_rec.object_version_number) THEN
2596: CLOSE Item_group_csr;
2597: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2598: FND_MSG_PUB.ADD;
2599: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: END IF;
2601:

Line 2606: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_POSN_EXISTS');

2602: -- Check if this item group has any positions associated.
2603: OPEN ahl_relationships_csr(p_item_group_rec.item_group_id);
2604: FETCH ahl_relationships_csr INTO l_dummy;
2605: IF (ahl_relationships_csr%FOUND) THEN
2606: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_POSN_EXISTS');
2607: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2608: FND_MSG_PUB.ADD;
2609: --dbms_output.put_line('Positions exist for this item group');
2610: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2607: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);

2603: OPEN ahl_relationships_csr(p_item_group_rec.item_group_id);
2604: FETCH ahl_relationships_csr INTO l_dummy;
2605: IF (ahl_relationships_csr%FOUND) THEN
2606: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_POSN_EXISTS');
2607: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2608: FND_MSG_PUB.ADD;
2609: --dbms_output.put_line('Positions exist for this item group');
2610: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2611: END IF;

Line 2619: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_COMP_EXISTS');

2615: -- Check if this item group has any composition associated.
2616: OPEN ahl_item_comp_csr(p_item_group_rec.item_group_id);
2617: FETCH ahl_item_comp_csr INTO l_dummy;
2618: IF (ahl_item_comp_csr%FOUND) THEN
2619: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_COMP_EXISTS');
2620: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2621: FND_MSG_PUB.ADD;
2622: --dbms_output.put_line('Positions exist for this item group');
2623: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2620: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);

2616: OPEN ahl_item_comp_csr(p_item_group_rec.item_group_id);
2617: FETCH ahl_item_comp_csr INTO l_dummy;
2618: IF (ahl_item_comp_csr%FOUND) THEN
2619: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_COMP_EXISTS');
2620: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2621: FND_MSG_PUB.ADD;
2622: --dbms_output.put_line('Positions exist for this item group');
2623: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2624: END IF;

Line 2633: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_APPR_PEND');

2629: -- Coded for 11.5.10
2630:
2631: IF l_item_group_rec.status_code ='APPROVAL_PENDING'
2632: THEN
2633: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_APPR_PEND');
2634: FND_MSG_PUB.ADD;
2635: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2636: END IF;
2637:

Line 2641: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_REMOVED');

2637:
2638:
2639: IF l_item_group_rec.status_code ='REMOVED'
2640: THEN
2641: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_REMOVED');
2642: FND_MSG_PUB.ADD;
2643: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2644: END IF;
2645:

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

2906: x_msg_data =>l_msg_data);
2907:
2908: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
2909: THEN
2910: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
2911: FND_MSG_PUB.ADD;
2912: END IF;
2913:
2914: IF p_source_item_group_id is null or p_source_item_group_id = FND_API.G_MISS_NUM

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

2912: END IF;
2913:
2914: IF p_source_item_group_id is null or p_source_item_group_id = FND_API.G_MISS_NUM
2915: THEN
2916: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
2917: FND_MSG_PUB.ADD;
2918: ELSE
2919: OPEN get_Itemgroup_Det(p_source_item_group_id);
2920: FETCH get_Itemgroup_Det INTO l_itemgroup_rec;

Line 2930: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_MOD_NAME');

2926: OPEN Item_group_name(l_itemgroup_rec.name);
2927: FETCH Item_group_name INTO l_dummy;
2928: IF Item_group_name%FOUND
2929: THEN
2930: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_MOD_NAME');
2931: FND_MSG_PUB.ADD;
2932: CLOSE Item_group_name;
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;

Line 2955: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_DRFT');

2951: Validate_Item_Group_Name(l_itemgroup_rec.name, p_source_item_group_id, l_itemgroup_rec.source_item_group_id);
2952: END IF;
2953:
2954: ELSE
2955: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_DRFT');
2956: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);
2957: FND_MSG_PUB.ADD;
2958: END IF;
2959: ELSE

Line 2956: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);

2952: END IF;
2953:
2954: ELSE
2955: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_DRFT');
2956: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);
2957: FND_MSG_PUB.ADD;
2958: END IF;
2959: ELSE
2960: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');

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

2956: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);
2957: FND_MSG_PUB.ADD;
2958: END IF;
2959: ELSE
2960: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');
2961: FND_MSG_PUB.ADD;
2962: END IF;
2963:
2964: OPEN validate_item_group(p_source_item_group_id);

Line 2967: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_INTERCHANGE_INAVLID');

2963:
2964: OPEN validate_item_group(p_source_item_group_id);
2965: FETCH validate_item_group INTO l_dummy;
2966: IF validate_item_group%NOTFOUND THEN
2967: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_INTERCHANGE_INAVLID');
2968: FND_MSG_PUB.ADD;
2969: END IF;
2970: CLOSE validate_item_group;
2971:

Line 2975: FND_MESSAGE.SET_NAME('AHL','AHL_MC_PAR_QTY_INV');

2971:
2972: OPEN validate_item_group_positions(p_source_item_group_id);
2973: FETCH validate_item_group_positions INTO l_dummy;
2974: IF validate_item_group_positions%FOUND THEN
2975: FND_MESSAGE.SET_NAME('AHL','AHL_MC_PAR_QTY_INV');
2976: FND_MESSAGE.set_token('POSREF','');
2977: FND_MSG_PUB.ADD;
2978: END IF;
2979: CLOSE validate_item_group_positions;

Line 2976: FND_MESSAGE.set_token('POSREF','');

2972: OPEN validate_item_group_positions(p_source_item_group_id);
2973: FETCH validate_item_group_positions INTO l_dummy;
2974: IF validate_item_group_positions%FOUND THEN
2975: FND_MESSAGE.SET_NAME('AHL','AHL_MC_PAR_QTY_INV');
2976: FND_MESSAGE.set_token('POSREF','');
2977: FND_MSG_PUB.ADD;
2978: END IF;
2979: CLOSE validate_item_group_positions;
2980:

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

3007: and OBJECT_VERSION_NUMBER=p_object_Version_number;
3008:
3009: IF sql%rowcount=0
3010: THEN
3011: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3012: FND_MSG_PUB.ADD;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015:

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

3293:
3294: OPEN get_itemgroup_det(p_source_ItemGroup_id);
3295: Fetch get_itemgroup_det into l_itemgroup_det;
3296: IF get_itemgroup_det%NOTFOUND THEN
3297: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
3298: FND_MSG_PUB.ADD;
3299: END IF;
3300: close get_itemgroup_det;
3301:

Line 3305: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_COMP');

3301:
3302:
3303: IF l_itemgroup_det.Status_Code <> 'COMPLETE'
3304: THEN
3305: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_COMP');
3306: FND_MESSAGE.Set_Token('IG',l_itemgroup_det.name);
3307: FND_MSG_PUB.ADD;
3308: END IF;
3309:

Line 3306: FND_MESSAGE.Set_Token('IG',l_itemgroup_det.name);

3302:
3303: IF l_itemgroup_det.Status_Code <> 'COMPLETE'
3304: THEN
3305: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_COMP');
3306: FND_MESSAGE.Set_Token('IG',l_itemgroup_det.name);
3307: FND_MSG_PUB.ADD;
3308: END IF;
3309:
3310:

Line 3313: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD');

3309:
3310:
3311: IF l_itemgroup_det.object_version_number <> p_object_version_number
3312: THEN
3313: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD');
3314: FND_MSG_PUB.ADD;
3315: END IF;
3316:
3317:

Line 3321: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_REVISION_EXIST');

3317:
3318: OPEN get_revision_info(p_source_ItemGroup_id);
3319: FETCH get_revision_info INTO l_dummy;
3320: IF get_revision_info%FOUND THEN
3321: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_REVISION_EXIST');
3322: FND_MSG_PUB.ADD;
3323: END IF;
3324: CLOSE get_revision_info;
3325:

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

3918: OPEN get_itemgroup_det(p_ItemGroups_id);
3919: FETCH get_itemgroup_det INTO l_itemgroup_det;
3920: IF get_itemgroup_det%NOTFOUND
3921: THEN
3922: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
3923: FND_MSG_PUB.ADD;
3924: END IF;
3925: CLOSE get_itemgroup_det;
3926:

Line 3929: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD');

3925: CLOSE get_itemgroup_det;
3926:
3927: IF l_itemgroup_det.object_version_number <> p_object_version_number
3928: THEN
3929: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD');
3930: FND_MSG_PUB.ADD;
3931: END IF;
3932:
3933:

Line 4289: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_DELETED');

4285: FETCH get_itemgroup_details INTO l_obj_ver_num, l_source_id, l_status;
4286: IF (get_itemgroup_details%NOTFOUND)
4287: THEN
4288: CLOSE get_itemgroup_details;
4289: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_DELETED');
4290: FND_MSG_PUB.ADD;
4291: RAISE FND_API.G_EXC_ERROR;
4292: ELSIF (l_obj_ver_num <> p_object_version_number)
4293: THEN

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

4291: RAISE FND_API.G_EXC_ERROR;
4292: ELSIF (l_obj_ver_num <> p_object_version_number)
4293: THEN
4294: CLOSE get_itemgroup_details;
4295: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
4296: FND_MSG_PUB.ADD;
4297: RAISE FND_API.G_EXC_ERROR;
4298: ELSIF (l_status <> 'DRAFT' or nvl(l_source_id, 0) <= 0)
4299: THEN

Line 4301: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOUPDATE');

4297: RAISE FND_API.G_EXC_ERROR;
4298: ELSIF (l_status <> 'DRAFT' or nvl(l_source_id, 0) <= 0)
4299: THEN
4300: CLOSE get_itemgroup_details;
4301: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOUPDATE');
4302: FND_MSG_PUB.ADD;
4303: RAISE FND_API.G_EXC_ERROR;
4304: END IF;
4305: CLOSE get_itemgroup_details;

Line 4320: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');

4316: -- Validate node exists, if yes, go ahead and unassociate the item group
4317: IF (check_position_exists%NOTFOUND)
4318: THEN
4319: CLOSE check_position_exists;
4320: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');
4321: FND_MSG_PUB.ADD;
4322: ELSIF (p_nodes_tbl(i).operation_flag = 'C')
4323: THEN
4324: UPDATE ahl_mc_relationships