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 924: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');

920: FETCH Item_assoc_csr INTO l_item_assoc_rec;
921: IF (Item_assoc_csr%NOTFOUND) THEN
922: CLOSE Item_assoc_csr;
923: -- SATHAPLI::Bug 9891818, 20-July-2010, replaced the following non-existent error message with an existing one
924: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');
925: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IA_INVALID'); -- Invalid association of item ITEM.
926: FND_MESSAGE.Set_Token('ITEM', l_x_item_assoc_rec.inventory_item_name);
927: FND_MSG_PUB.ADD;
928: --dbms_output.put_line('Item Assoc does not exist');

Line 925: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IA_INVALID'); -- Invalid association of item ITEM.

921: IF (Item_assoc_csr%NOTFOUND) THEN
922: CLOSE Item_assoc_csr;
923: -- SATHAPLI::Bug 9891818, 20-July-2010, replaced the following non-existent error message with an existing one
924: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');
925: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IA_INVALID'); -- Invalid association of item ITEM.
926: FND_MESSAGE.Set_Token('ITEM', l_x_item_assoc_rec.inventory_item_name);
927: FND_MSG_PUB.ADD;
928: --dbms_output.put_line('Item Assoc does not exist');
929: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 926: FND_MESSAGE.Set_Token('ITEM', l_x_item_assoc_rec.inventory_item_name);

922: CLOSE Item_assoc_csr;
923: -- SATHAPLI::Bug 9891818, 20-July-2010, replaced the following non-existent error message with an existing one
924: -- FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_ASSOS_NOT_EXISTS');
925: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IA_INVALID'); -- Invalid association of item ITEM.
926: FND_MESSAGE.Set_Token('ITEM', l_x_item_assoc_rec.inventory_item_name);
927: FND_MSG_PUB.ADD;
928: --dbms_output.put_line('Item Assoc does not exist');
929: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2052: -- IF (l_old_item_group_rec.object_version_number <> NVL(p_item_group_rec.object_version_number,0)) THEN
2053: IF (NVL(l_old_item_group_rec.sourced_from_enigma_flag, 'N') = 'N' AND
2054: l_old_item_group_rec.object_version_number <> NVL(p_item_group_rec.object_version_number,0)) THEN
2055: CLOSE Item_group_csr;
2056: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2057: FND_MSG_PUB.ADD;
2058: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060:

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

2073: -- TAMAL -- IG Amendments --
2074: ELSIF (l_old_item_group_rec.name <> p_item_group_rec.name )
2075: THEN
2076: CLOSE Item_group_csr;
2077: FND_MESSAGE.Set_Name('AHL','AHL_COM_KEY_NOUPDATE');
2078: FND_MSG_PUB.ADD;
2079: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2080: END IF;
2081:

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

2084: IF NVL(l_old_item_group_rec.sourced_from_enigma_flag, 'N') = 'N' AND
2085: l_old_item_group_rec.status_code in ('COMPLETE','APPROVAL_PENDING')
2086: THEN
2087: CLOSE Item_group_csr;
2088: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOUPDATE');
2089: FND_MESSAGE.Set_Token('STATUS',p_item_group_rec.status_code);
2090: FND_MSG_PUB.ADD;
2091: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2092: --dbms_output.put_line('Item Group cannot be updated if status is Complete or Approval Rejected');

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

2085: l_old_item_group_rec.status_code in ('COMPLETE','APPROVAL_PENDING')
2086: THEN
2087: CLOSE Item_group_csr;
2088: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_NOUPDATE');
2089: FND_MESSAGE.Set_Token('STATUS',p_item_group_rec.status_code);
2090: FND_MSG_PUB.ADD;
2091: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2092: --dbms_output.put_line('Item Group cannot be updated if status is Complete or Approval Rejected');
2093: END IF;

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

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

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

2105:
2106: IF (p_item_group_rec.type_code <> FND_API.G_MISS_CHAR) THEN
2107: IF (p_item_group_rec.type_code <> l_old_item_group_rec.type_code)
2108: THEN
2109: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');
2110: FND_MSG_PUB.ADD;
2111: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2112: --dbms_output.put_line('Item Group Type cannot be updated');
2113: END IF;

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

2126:
2127: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
2128: -- Check if association record belongs to the item group.
2129: IF (p_x_items_tbl(i).item_group_id <> p_item_group_rec.item_group_id) THEN
2130: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
2131: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2132: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2133: FND_MSG_PUB.ADD;
2134: --dbms_output.put_line('Item Association record does not match Item Group');

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

2127: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
2128: -- Check if association record belongs to the item group.
2129: IF (p_x_items_tbl(i).item_group_id <> p_item_group_rec.item_group_id) THEN
2130: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
2131: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2132: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2133: FND_MSG_PUB.ADD;
2134: --dbms_output.put_line('Item Association record does not match Item Group');
2135: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

2128: -- Check if association record belongs to the item group.
2129: IF (p_x_items_tbl(i).item_group_id <> p_item_group_rec.item_group_id) THEN
2130: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_MISMATCH');
2131: FND_MESSAGE.Set_Token('ITEM_GRP',p_item_group_rec.item_group_id);
2132: FND_MESSAGE.Set_Token('ASSO_GRP',p_x_items_tbl(i).item_group_id);
2133: FND_MSG_PUB.ADD;
2134: --dbms_output.put_line('Item Association record does not match Item Group');
2135: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2136: END IF;

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

2593: OPEN Item_group_csr(p_item_group_rec.item_group_id);
2594: FETCH Item_group_csr INTO l_item_group_rec;
2595: IF (Item_group_csr%NOTFOUND) THEN
2596: CLOSE Item_group_csr;
2597: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
2598: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2599: FND_MSG_PUB.ADD;
2600: --dbms_output.put_line('Item Group does not exist');
2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

2594: FETCH Item_group_csr INTO l_item_group_rec;
2595: IF (Item_group_csr%NOTFOUND) THEN
2596: CLOSE Item_group_csr;
2597: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_INVALID');
2598: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2599: FND_MSG_PUB.ADD;
2600: --dbms_output.put_line('Item Group does not exist');
2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2602: END IF;

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

2603:
2604: -- Check Object version number.
2605: IF (l_item_group_rec.object_version_number <> p_item_group_rec.object_version_number) THEN
2606: CLOSE Item_group_csr;
2607: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2608: FND_MSG_PUB.ADD;
2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2610: END IF;
2611:

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

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

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

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

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

2625: -- Check if this item group has any composition associated.
2626: OPEN ahl_item_comp_csr(p_item_group_rec.item_group_id);
2627: FETCH ahl_item_comp_csr INTO l_dummy;
2628: IF (ahl_item_comp_csr%FOUND) THEN
2629: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_COMP_EXISTS');
2630: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2631: FND_MSG_PUB.ADD;
2632: --dbms_output.put_line('Positions exist for this item group');
2633: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

2626: OPEN ahl_item_comp_csr(p_item_group_rec.item_group_id);
2627: FETCH ahl_item_comp_csr INTO l_dummy;
2628: IF (ahl_item_comp_csr%FOUND) THEN
2629: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_COMP_EXISTS');
2630: FND_MESSAGE.Set_Token('ITEM_GRP',l_item_group_rec.name);
2631: FND_MSG_PUB.ADD;
2632: --dbms_output.put_line('Positions exist for this item group');
2633: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2634: END IF;

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

2639: -- Coded for 11.5.10
2640:
2641: IF l_item_group_rec.status_code ='APPROVAL_PENDING'
2642: THEN
2643: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_APPR_PEND');
2644: FND_MSG_PUB.ADD;
2645: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END IF;
2647:

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

2647:
2648:
2649: IF l_item_group_rec.status_code ='REMOVED'
2650: THEN
2651: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEMGRP_REMOVED');
2652: FND_MSG_PUB.ADD;
2653: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2654: END IF;
2655:

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

2916: x_msg_data =>l_msg_data);
2917:
2918: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
2919: THEN
2920: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
2921: FND_MSG_PUB.ADD;
2922: END IF;
2923:
2924: IF p_source_item_group_id is null or p_source_item_group_id = FND_API.G_MISS_NUM

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

2922: END IF;
2923:
2924: IF p_source_item_group_id is null or p_source_item_group_id = FND_API.G_MISS_NUM
2925: THEN
2926: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
2927: FND_MSG_PUB.ADD;
2928: ELSE
2929: OPEN get_Itemgroup_Det(p_source_item_group_id);
2930: FETCH get_Itemgroup_Det INTO l_itemgroup_rec;

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

2936: OPEN Item_group_name(l_itemgroup_rec.name);
2937: FETCH Item_group_name INTO l_dummy;
2938: IF Item_group_name%FOUND
2939: THEN
2940: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_MOD_NAME');
2941: FND_MSG_PUB.ADD;
2942: CLOSE Item_group_name;
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;

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

2961: Validate_Item_Group_Name(l_itemgroup_rec.name, p_source_item_group_id, l_itemgroup_rec.source_item_group_id);
2962: END IF;
2963:
2964: ELSE
2965: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_DRFT');
2966: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);
2967: FND_MSG_PUB.ADD;
2968: END IF;
2969: ELSE

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

2962: END IF;
2963:
2964: ELSE
2965: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_DRFT');
2966: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);
2967: FND_MSG_PUB.ADD;
2968: END IF;
2969: ELSE
2970: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');

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

2966: FND_MESSAGE.set_token('IG',l_itemgroup_rec.name,false);
2967: FND_MSG_PUB.ADD;
2968: END IF;
2969: ELSE
2970: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_TYPE_CODE_MISSING');
2971: FND_MSG_PUB.ADD;
2972: END IF;
2973:
2974: OPEN validate_item_group(p_source_item_group_id);

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

2973:
2974: OPEN validate_item_group(p_source_item_group_id);
2975: FETCH validate_item_group INTO l_dummy;
2976: IF validate_item_group%NOTFOUND THEN
2977: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_INTERCHANGE_INAVLID');
2978: FND_MSG_PUB.ADD;
2979: END IF;
2980: CLOSE validate_item_group;
2981:

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

2981:
2982: OPEN validate_item_group_positions(p_source_item_group_id);
2983: FETCH validate_item_group_positions INTO l_dummy;
2984: IF validate_item_group_positions%FOUND THEN
2985: FND_MESSAGE.SET_NAME('AHL','AHL_MC_PAR_QTY_INV');
2986: FND_MESSAGE.set_token('POSREF','');
2987: FND_MSG_PUB.ADD;
2988: END IF;
2989: CLOSE validate_item_group_positions;

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

2982: OPEN validate_item_group_positions(p_source_item_group_id);
2983: FETCH validate_item_group_positions INTO l_dummy;
2984: IF validate_item_group_positions%FOUND THEN
2985: FND_MESSAGE.SET_NAME('AHL','AHL_MC_PAR_QTY_INV');
2986: FND_MESSAGE.set_token('POSREF','');
2987: FND_MSG_PUB.ADD;
2988: END IF;
2989: CLOSE validate_item_group_positions;
2990:

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

3017: and OBJECT_VERSION_NUMBER=p_object_Version_number;
3018:
3019: IF sql%rowcount=0
3020: THEN
3021: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3022: FND_MSG_PUB.ADD;
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025:

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

3303:
3304: OPEN get_itemgroup_det(p_source_ItemGroup_id);
3305: Fetch get_itemgroup_det into l_itemgroup_det;
3306: IF get_itemgroup_det%NOTFOUND THEN
3307: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
3308: FND_MSG_PUB.ADD;
3309: END IF;
3310: close get_itemgroup_det;
3311:

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

3311:
3312:
3313: IF l_itemgroup_det.Status_Code <> 'COMPLETE'
3314: THEN
3315: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_COMP');
3316: FND_MESSAGE.Set_Token('IG',l_itemgroup_det.name);
3317: FND_MSG_PUB.ADD;
3318: END IF;
3319:

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

3312:
3313: IF l_itemgroup_det.Status_Code <> 'COMPLETE'
3314: THEN
3315: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_STAT_NOT_COMP');
3316: FND_MESSAGE.Set_Token('IG',l_itemgroup_det.name);
3317: FND_MSG_PUB.ADD;
3318: END IF;
3319:
3320:

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

3319:
3320:
3321: IF l_itemgroup_det.object_version_number <> p_object_version_number
3322: THEN
3323: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD');
3324: FND_MSG_PUB.ADD;
3325: END IF;
3326:
3327:

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

3327:
3328: OPEN get_revision_info(p_source_ItemGroup_id);
3329: FETCH get_revision_info INTO l_dummy;
3330: IF get_revision_info%FOUND THEN
3331: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IG_REVISION_EXIST');
3332: FND_MSG_PUB.ADD;
3333: END IF;
3334: CLOSE get_revision_info;
3335:

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

3928: OPEN get_itemgroup_det(p_ItemGroups_id);
3929: FETCH get_itemgroup_det INTO l_itemgroup_det;
3930: IF get_itemgroup_det%NOTFOUND
3931: THEN
3932: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
3933: FND_MSG_PUB.ADD;
3934: END IF;
3935: CLOSE get_itemgroup_det;
3936:

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

3935: CLOSE get_itemgroup_det;
3936:
3937: IF l_itemgroup_det.object_version_number <> p_object_version_number
3938: THEN
3939: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD');
3940: FND_MSG_PUB.ADD;
3941: END IF;
3942:
3943:

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

4311: FETCH get_itemgroup_details INTO l_obj_ver_num, l_source_id, l_status;
4312: IF (get_itemgroup_details%NOTFOUND)
4313: THEN
4314: CLOSE get_itemgroup_details;
4315: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_DELETED');
4316: FND_MSG_PUB.ADD;
4317: RAISE FND_API.G_EXC_ERROR;
4318: ELSIF (l_obj_ver_num <> p_object_version_number)
4319: THEN

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

4317: RAISE FND_API.G_EXC_ERROR;
4318: ELSIF (l_obj_ver_num <> p_object_version_number)
4319: THEN
4320: CLOSE get_itemgroup_details;
4321: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
4322: FND_MSG_PUB.ADD;
4323: RAISE FND_API.G_EXC_ERROR;
4324: ELSIF (l_status <> 'DRAFT' or nvl(l_source_id, 0) <= 0)
4325: THEN

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

4323: RAISE FND_API.G_EXC_ERROR;
4324: ELSIF (l_status <> 'DRAFT' or nvl(l_source_id, 0) <= 0)
4325: THEN
4326: CLOSE get_itemgroup_details;
4327: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOUPDATE');
4328: FND_MSG_PUB.ADD;
4329: RAISE FND_API.G_EXC_ERROR;
4330: END IF;
4331: CLOSE get_itemgroup_details;

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

4342: -- Validate node exists, if yes, go ahead and unassociate the item group
4343: IF (check_position_exists%NOTFOUND)
4344: THEN
4345: CLOSE check_position_exists;
4346: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');
4347: FND_MSG_PUB.ADD;
4348: ELSIF (p_nodes_tbl(i).operation_flag = 'C')
4349: THEN
4350: UPDATE ahl_mc_relationships