eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MC_ITEM_COMP_PVT dependencies on FND_API

Line 128: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN

124:
125:
126:
127: -- Check if UOM entered and valid.
128: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
129: -- uom_code is null but quantity is not null.
130: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
131: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_NULL');
132: FND_MESSAGE.Set_Token('IG',p_item_group_name);

Line 130: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN

126:
127: -- Check if UOM entered and valid.
128: IF (p_uom_code IS NULL OR p_uom_code = FND_API.G_MISS_CHAR) THEN
129: -- uom_code is null but quantity is not null.
130: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
131: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_UOM_NULL');
132: FND_MESSAGE.Set_Token('IG',p_item_group_name);
133: FND_MSG_PUB.ADD;
134: ELSE

Line 163: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN

159: END IF;
160: END IF ;
161:
162: -- Validate quantity.
163: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
164: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
165: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_NULL');
166: FND_MESSAGE.Set_Token('IG',p_item_group_name);
167: FND_MSG_PUB.ADD;

Line 164: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN

160: END IF ;
161:
162: -- Validate quantity.
163: IF (p_quantity IS NULL OR p_quantity = FND_API.G_MISS_NUM) THEN
164: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
165: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_NULL');
166: FND_MESSAGE.Set_Token('IG',p_item_group_name);
167: FND_MSG_PUB.ADD;
168: ELSE

Line 175: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN

171: FND_MSG_PUB.ADD;
172: END IF;
173: --dbms_output.put_line('Quantity is null');
174: ELSIF (p_quantity < 0) THEN
175: IF (p_inv_segment IS NULL OR p_inv_segment = FND_API.G_MISS_CHAR) THEN
176: FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_QTY_INVALID');
177: FND_MESSAGE.Set_Token('IG',p_item_group_name);
178: FND_MESSAGE.Set_Token('QUANTITY',p_quantity);
179: FND_MSG_PUB.ADD;

Line 362: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

358: -- Pre-reqs :
359: -- Parameters :
360: -- Standard IN Parameters :
361: -- p_api_version IN NUMBER Required
362: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
364: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
365: --
366: -- Standard OUT Parameters :

Line 363: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

359: -- Parameters :
360: -- Standard IN Parameters :
361: -- p_api_version IN NUMBER Required
362: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
364: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
365: --
366: -- Standard OUT Parameters :
367: -- x_return_status OUT VARCHAR2 Required

Line 364: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

360: -- Standard IN Parameters :
361: -- p_api_version IN NUMBER Required
362: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
363: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
364: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
365: --
366: -- Standard OUT Parameters :
367: -- x_return_status OUT VARCHAR2 Required
368: -- x_msg_count OUT NUMBER Required

Line 388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

384: -- End of Comments --
385:
386: PROCEDURE Create_Item_Composition(
387: p_api_version IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: p_commit IN VARCHAR2 := FND_API.G_FALSE,
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,

Line 389: p_commit IN VARCHAR2 := FND_API.G_FALSE,

385:
386: PROCEDURE Create_Item_Composition(
387: p_api_version IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: p_commit IN VARCHAR2 := FND_API.G_FALSE,
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,

Line 390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

386: PROCEDURE Create_Item_Composition(
387: p_api_version IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: p_commit IN VARCHAR2 := FND_API.G_FALSE,
390: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

Line 420: IF FND_API.to_boolean(p_init_msg_list) THEN

416:
417:
418: -- Standard call to check for call compatibility.
419:
420: IF FND_API.to_boolean(p_init_msg_list) THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: -- Initialize API return status to success

Line 426: x_return_status :=FND_API.G_RET_STS_SUCCESS;

422: END IF;
423:
424: -- Initialize API return status to success
425:
426: x_return_status :=FND_API.G_RET_STS_SUCCESS;
427:
428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
429: THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 449: RAISE FND_API.G_EXC_ERROR;

445: IF item_composition_dup%FOUND THEN
446: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');
447: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_name);
448: FND_MSG_PUB.ADD;
449: RAISE FND_API.G_EXC_ERROR;
450: END IF;
451:
452: CLOSE item_composition_dup;
453:

Line 554: RAISE FND_API.G_EXC_ERROR;

550:
551: -- Check Error Message stack.
552: x_msg_count := FND_MSG_PUB.count_msg;
553: IF x_msg_count > 0 THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:
557:
558: p_x_ic_header_rec.ITEM_COMPOSITION_ID := l_item_composition_id;

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564: END IF;
565:
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: Rollback to Create_Item_Composition;
571: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
572: p_data => x_msg_data,

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565:
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: Rollback to Create_Item_Composition;
571: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
572: p_data => x_msg_data,
573: p_encoded => fnd_api.g_false);

Line 573: p_encoded => fnd_api.g_false);

569: x_return_status := FND_API.G_RET_STS_ERROR;
570: Rollback to Create_Item_Composition;
571: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
572: p_data => x_msg_data,
573: p_encoded => fnd_api.g_false);
574:
575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
576: THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

578: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Error in Create_Item_Composition');
579: END IF;
580:
581:
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: Rollback to Create_Item_Composition;
585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
586: p_data => x_msg_data,

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

579: END IF;
580:
581:
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: Rollback to Create_Item_Composition;
585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
586: p_data => x_msg_data,
587: p_encoded => fnd_api.g_false);

Line 587: p_encoded => fnd_api.g_false);

583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: Rollback to Create_Item_Composition;
585: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
586: p_data => x_msg_data,
587: p_encoded => fnd_api.g_false);
588:
589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
590: THEN
591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

592: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Composition', 'Unexpected Error in Create_Item_Composition');
593: END IF;
594:
595: WHEN OTHERS THEN
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: Rollback to Create_Item_Composition;
598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
599: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
600: p_procedure_name => 'Create_Item_Composition',

Line 605: p_encoded => fnd_api.g_false);

601: p_error_text => SUBSTR(SQLERRM,1,240));
602: END IF;
603: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
604: p_data => x_msg_data,
605: p_encoded => fnd_api.g_false);
606:
607: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
608: THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 628: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

624: -- Pre-reqs :
625: -- Parameters :
626: -- Standard IN Parameters :
627: -- p_api_version IN NUMBER Required
628: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
629: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
630: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
631: --
632: -- Standard OUT Parameters :

Line 629: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

625: -- Parameters :
626: -- Standard IN Parameters :
627: -- p_api_version IN NUMBER Required
628: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
629: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
630: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
631: --
632: -- Standard OUT Parameters :
633: -- x_return_status OUT VARCHAR2 Required

Line 630: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

626: -- Standard IN Parameters :
627: -- p_api_version IN NUMBER Required
628: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
629: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
630: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
631: --
632: -- Standard OUT Parameters :
633: -- x_return_status OUT VARCHAR2 Required
634: -- x_msg_count OUT NUMBER Required

Line 654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

650: -- End of Comments --
651:
652: PROCEDURE Modify_Item_Composition(
653: p_api_version IN NUMBER,
654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,

Line 655: p_commit IN VARCHAR2 := FND_API.G_FALSE,

651:
652: PROCEDURE Modify_Item_Composition(
653: p_api_version IN NUMBER,
654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,
659: x_msg_data OUT NOCOPY VARCHAR2,

Line 656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

652: PROCEDURE Modify_Item_Composition(
653: p_api_version IN NUMBER,
654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,
659: x_msg_data OUT NOCOPY VARCHAR2,
660: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,

Line 713: IF FND_API.to_boolean(p_init_msg_list) THEN

709:
710:
711: -- Standard call to check for call compatibility.
712:
713: IF FND_API.to_boolean(p_init_msg_list) THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:
717: -- Initialize API return status to success

Line 719: x_return_status :=FND_API.G_RET_STS_SUCCESS;

715: END IF;
716:
717: -- Initialize API return status to success
718:
719: x_return_status :=FND_API.G_RET_STS_SUCCESS;
720:
721: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
722: THEN
723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 734: RAISE FND_API.G_EXC_ERROR;

730: FETCH item_composition_det INTO l_item_composition_rec;
731: IF item_composition_det%NOTFOUND THEN
732: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736:
737: CLOSE item_composition_det;
738:

Line 743: RAISE FND_API.G_EXC_ERROR;

739:
740: IF l_item_composition_rec.object_version_number <> p_x_ic_header_rec.object_version_number THEN
741: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
742: FND_MSG_PUB.ADD;
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;
745:
746:
747: IF l_item_composition_rec.approval_status_code NOT IN ('DRAFT','APPROVAL_REJECTED') THEN

Line 750: RAISE FND_API.G_EXC_ERROR;

746:
747: IF l_item_composition_rec.approval_status_code NOT IN ('DRAFT','APPROVAL_REJECTED') THEN
748: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_EDIT');
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752:
753:
754: IF (l_item_composition_rec.approval_status_code = 'APPROVAL_REJECTED') THEN

Line 830: RAISE FND_API.G_EXC_ERROR;

826:
827: -- Check Error Message stack.
828: x_msg_count := FND_MSG_PUB.count_msg;
829: IF x_msg_count > 0 THEN
830: RAISE FND_API.G_EXC_ERROR;
831: END IF;
832:
833:
834: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 843: WHEN FND_API.G_EXC_ERROR THEN

839:
840:
841:
842: EXCEPTION
843: WHEN FND_API.G_EXC_ERROR THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: Rollback to Modify_Item_Composition;
846: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
847: p_data => x_msg_data,

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840:
841:
842: EXCEPTION
843: WHEN FND_API.G_EXC_ERROR THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: Rollback to Modify_Item_Composition;
846: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
847: p_data => x_msg_data,
848: p_encoded => fnd_api.g_false);

Line 848: p_encoded => fnd_api.g_false);

844: x_return_status := FND_API.G_RET_STS_ERROR;
845: Rollback to Modify_Item_Composition;
846: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
847: p_data => x_msg_data,
848: p_encoded => fnd_api.g_false);
849:
850: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
851: THEN
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

853: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Error in Modify_Item_Composition');
854: END IF;
855:
856:
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: Rollback to Modify_Item_Composition;
860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
861: p_data => x_msg_data,

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854: END IF;
855:
856:
857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: Rollback to Modify_Item_Composition;
860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
861: p_data => x_msg_data,
862: p_encoded => fnd_api.g_false);

Line 862: p_encoded => fnd_api.g_false);

858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859: Rollback to Modify_Item_Composition;
860: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
861: p_data => x_msg_data,
862: p_encoded => fnd_api.g_false);
863:
864: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
865: THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

867: 'ahl.plsql.'||G_PKG_NAME||'.Modify_Item_Composition', 'Unexpected Error in Modify_Item_Composition');
868: END IF;
869:
870: WHEN OTHERS THEN
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
872: Rollback to Modify_Item_Composition;
873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
874: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
875: p_procedure_name => 'Modify_Item_Composition',

Line 880: p_encoded => fnd_api.g_false);

876: p_error_text => SUBSTR(SQLERRM,1,240));
877: END IF;
878: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
879: p_data => x_msg_data,
880: p_encoded => fnd_api.g_false);
881:
882: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
883: THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 903: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

899: -- Pre-reqs :
900: -- Parameters :
901: -- Standard IN Parameters :
902: -- p_api_version IN NUMBER Required
903: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
904: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
905: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
906: --
907: -- Standard OUT Parameters :

Line 904: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

900: -- Parameters :
901: -- Standard IN Parameters :
902: -- p_api_version IN NUMBER Required
903: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
904: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
905: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
906: --
907: -- Standard OUT Parameters :
908: -- x_return_status OUT VARCHAR2 Required

Line 905: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

901: -- Standard IN Parameters :
902: -- p_api_version IN NUMBER Required
903: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
904: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
905: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
906: --
907: -- Standard OUT Parameters :
908: -- x_return_status OUT VARCHAR2 Required
909: -- x_msg_count OUT NUMBER Required

Line 918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

914: -- End of Comments --
915:
916: PROCEDURE Delete_Item_Composition (
917: p_api_version IN NUMBER,
918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
919: p_commit IN VARCHAR2 := FND_API.G_FALSE,
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: x_return_status OUT NOCOPY VARCHAR2,
922: x_msg_count OUT NOCOPY NUMBER,

Line 919: p_commit IN VARCHAR2 := FND_API.G_FALSE,

915:
916: PROCEDURE Delete_Item_Composition (
917: p_api_version IN NUMBER,
918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
919: p_commit IN VARCHAR2 := FND_API.G_FALSE,
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: x_return_status OUT NOCOPY VARCHAR2,
922: x_msg_count OUT NOCOPY NUMBER,
923: x_msg_data OUT NOCOPY VARCHAR2,

Line 920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

916: PROCEDURE Delete_Item_Composition (
917: p_api_version IN NUMBER,
918: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
919: p_commit IN VARCHAR2 := FND_API.G_FALSE,
920: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921: x_return_status OUT NOCOPY VARCHAR2,
922: x_msg_count OUT NOCOPY NUMBER,
923: x_msg_data OUT NOCOPY VARCHAR2,
924: p_item_composition_ID IN NUMBER ,

Line 998: IF FND_API.to_boolean(p_init_msg_list) THEN

994:
995:
996: -- Standard call to check for call compatibility.
997:
998: IF FND_API.to_boolean(p_init_msg_list) THEN
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:
1002: -- Initialize API return status to success

Line 1004: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1000: END IF;
1001:
1002: -- Initialize API return status to success
1003:
1004: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1005:
1006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1007: THEN
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1019: RAISE FND_API.G_EXC_ERROR;

1015: FETCH item_composition_det INTO l_item_composition_rec;
1016: IF item_composition_det%NOTFOUND THEN
1017: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021:
1022: CLOSE item_composition_det;
1023:

Line 1028: RAISE FND_API.G_EXC_ERROR;

1024:
1025: IF l_item_composition_rec.object_version_number <> p_object_version_number THEN
1026: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1027: FND_MSG_PUB.ADD;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031:
1032: IF l_item_composition_rec.approval_status_code = 'APPROVAL_PENDING' THEN

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031:
1032: IF l_item_composition_rec.approval_status_code = 'APPROVAL_PENDING' THEN
1033: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_DELETE');
1034: FND_MSG_PUB.ADD;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038:
1039: -- Check Error Message stack.

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038:
1039: -- Check Error Message stack.
1040: x_msg_count := FND_MSG_PUB.count_msg;
1041: IF x_msg_count > 0 THEN
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045:
1046: IF l_item_composition_rec.approval_status_code = 'COMPLETE' THEN

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050: FETCH disposition_exist INTO l_dummy;
1051: IF disposition_exist%FOUND THEN
1052: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_DISP_EXISTS');
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057: CLOSE disposition_exist;
1058:

Line 1064: RAISE FND_API.G_EXC_ERROR;

1060: FETCH item_rev_exists INTO l_rev_item_composition_id;
1061: IF item_rev_exists%FOUND THEN
1062: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_REV_EXISTS');
1063: FND_MSG_PUB.ADD;
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: CLOSE item_rev_exists;
1067:
1068:

Line 1073: RAISE FND_API.G_EXC_ERROR;

1069: IF l_item_composition_rec.effective_end_date IS NOT NULL AND
1070: TRUNC(l_item_composition_rec.effective_end_date) <= TRUNC(SYSDATE) THEN
1071: FND_MESSAGE.Set_Name('AHL','AHL_MC_COMP_STATUS_NO_DELETE');
1072: FND_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075:
1076:
1077:

Line 1110: WHEN FND_API.G_EXC_ERROR THEN

1106: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'End of Delete_Item_Composition');
1107: END IF;
1108:
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: Rollback to Delete_Item_Composition;
1113: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1114: p_data => x_msg_data,

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

1107: END IF;
1108:
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: Rollback to Delete_Item_Composition;
1113: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1114: p_data => x_msg_data,
1115: p_encoded => fnd_api.g_false);

Line 1115: p_encoded => fnd_api.g_false);

1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: Rollback to Delete_Item_Composition;
1113: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1114: p_data => x_msg_data,
1115: p_encoded => fnd_api.g_false);
1116:
1117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1118: THEN
1119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1120: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Error in Delete_Item_Composition');
1121: END IF;
1122:
1123:
1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126: Rollback to Delete_Item_Composition;
1127: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1128: p_data => x_msg_data,

Line 1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1121: END IF;
1122:
1123:
1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126: Rollback to Delete_Item_Composition;
1127: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1128: p_data => x_msg_data,
1129: p_encoded => fnd_api.g_false);

Line 1129: p_encoded => fnd_api.g_false);

1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126: Rollback to Delete_Item_Composition;
1127: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1128: p_data => x_msg_data,
1129: p_encoded => fnd_api.g_false);
1130:
1131: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1132: THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1134: 'ahl.plsql.'||G_PKG_NAME||'.Delete_Item_Composition', 'Unexpected Error in Delete_Item_Composition');
1135: END IF;
1136:
1137: WHEN OTHERS THEN
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: Rollback to Delete_Item_Composition;
1140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1141: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1142: p_procedure_name => 'Delete_Item_Composition',

Line 1147: p_encoded => fnd_api.g_false);

1143: p_error_text => SUBSTR(SQLERRM,1,240));
1144: END IF;
1145: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1146: p_data => x_msg_data,
1147: p_encoded => fnd_api.g_false);
1148:
1149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1167: -- Pre-reqs :
1168: -- Parameters :
1169: -- Standard IN Parameters :
1170: -- p_api_version IN NUMBER Required
1171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1174: --
1175: -- Standard OUT Parameters :

Line 1172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1168: -- Parameters :
1169: -- Standard IN Parameters :
1170: -- p_api_version IN NUMBER Required
1171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1174: --
1175: -- Standard OUT Parameters :
1176: -- x_return_status OUT VARCHAR2 Required

Line 1173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1169: -- Standard IN Parameters :
1170: -- p_api_version IN NUMBER Required
1171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1174: --
1175: -- Standard OUT Parameters :
1176: -- x_return_status OUT VARCHAR2 Required
1177: -- x_msg_count OUT NUMBER Required

Line 1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1182: -- End of Comments --
1183:
1184: PROCEDURE Reopen_Item_Composition (
1185: p_api_version IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1189: x_return_status OUT NOCOPY VARCHAR2,
1190: x_msg_count OUT NOCOPY NUMBER,

Line 1187: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1183:
1184: PROCEDURE Reopen_Item_Composition (
1185: p_api_version IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1189: x_return_status OUT NOCOPY VARCHAR2,
1190: x_msg_count OUT NOCOPY NUMBER,
1191: x_msg_data OUT NOCOPY VARCHAR2,

Line 1188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1184: PROCEDURE Reopen_Item_Composition (
1185: p_api_version IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1187: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1188: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1189: x_return_status OUT NOCOPY VARCHAR2,
1190: x_msg_count OUT NOCOPY NUMBER,
1191: x_msg_data OUT NOCOPY VARCHAR2,
1192: p_item_composition_ID IN NUMBER ,

Line 1258: IF FND_API.to_boolean(p_init_msg_list) THEN

1254:
1255:
1256: -- Standard call to check for call compatibility.
1257:
1258: IF FND_API.to_boolean(p_init_msg_list) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:
1262: -- Initialize API return status to success

Line 1264: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1260: END IF;
1261:
1262: -- Initialize API return status to success
1263:
1264: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1265:
1266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1267: THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1277: RAISE FND_API.G_EXC_ERROR;

1273: FETCH item_composition_det INTO l_item_composition_rec;
1274: IF item_composition_det%NOTFOUND THEN
1275: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_NOT_EXISTS');
1276: FND_MSG_PUB.ADD;
1277: RAISE FND_API.G_EXC_ERROR;
1278: END IF;
1279:
1280: CLOSE item_composition_det;
1281:

Line 1286: RAISE FND_API.G_EXC_ERROR;

1282:
1283: IF l_item_composition_rec.object_version_number <> p_object_version_number THEN
1284: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1285: FND_MSG_PUB.ADD;
1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;
1288:
1289: /*
1290: OPEN item_composition_exists(l_item_composition_rec.inventory_item_id,

Line 1297: RAISE FND_API.G_EXC_ERROR;

1293: IF item_composition_exists%FOUND THEN
1294: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_EXISTS');
1295: FND_MESSAGE.Set_Token('INV_ITEM',p_x_ic_header_rec.inventory_item_id);
1296: FND_MSG_PUB.ADD;
1297: RAISE FND_API.G_EXC_ERROR;
1298: END IF;
1299:
1300: CLOSE item_composition_exists;
1301: */

Line 1307: RAISE FND_API.G_EXC_ERROR;

1303:
1304: IF NVL(l_item_composition_rec.effective_end_date,TRUNC(SYSDATE)) >= TRUNC(SYSDATE) THEN
1305: FND_MESSAGE.Set_Name('AHL','AHL_MC_ITEM_COMP_OPEN');
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308: END IF;
1309:
1310:
1311: -- Check Error Message stack.

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310:
1311: -- Check Error Message stack.
1312: x_msg_count := FND_MSG_PUB.count_msg;
1313: IF x_msg_count > 0 THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF;
1316:
1317:
1318:

Line 1332: IF FND_API.TO_BOOLEAN(p_commit) THEN

1328: AND OBJECT_VERSION_NUMBER = p_object_version_number;
1329:
1330:
1331: -- Standard check of p_commit
1332: IF FND_API.TO_BOOLEAN(p_commit) THEN
1333: COMMIT WORK;
1334: END IF;
1335:
1336:

Line 1338: WHEN FND_API.G_EXC_ERROR THEN

1334: END IF;
1335:
1336:
1337: EXCEPTION
1338: WHEN FND_API.G_EXC_ERROR THEN
1339: x_return_status := FND_API.G_RET_STS_ERROR;
1340: Rollback to Reopen_Item_Composition;
1341: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1342: p_data => x_msg_data,

Line 1339: x_return_status := FND_API.G_RET_STS_ERROR;

1335:
1336:
1337: EXCEPTION
1338: WHEN FND_API.G_EXC_ERROR THEN
1339: x_return_status := FND_API.G_RET_STS_ERROR;
1340: Rollback to Reopen_Item_Composition;
1341: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => fnd_api.g_false);

Line 1343: p_encoded => fnd_api.g_false);

1339: x_return_status := FND_API.G_RET_STS_ERROR;
1340: Rollback to Reopen_Item_Composition;
1341: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => fnd_api.g_false);
1344:
1345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1346: THEN
1347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1348: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Error in Reopen_Item_Composition');
1349: END IF;
1350:
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: Rollback to Reopen_Item_Composition;
1355: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1356: p_data => x_msg_data,

Line 1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1349: END IF;
1350:
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: Rollback to Reopen_Item_Composition;
1355: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1356: p_data => x_msg_data,
1357: p_encoded => fnd_api.g_false);

Line 1357: p_encoded => fnd_api.g_false);

1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: Rollback to Reopen_Item_Composition;
1355: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1356: p_data => x_msg_data,
1357: p_encoded => fnd_api.g_false);
1358:
1359: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1360: THEN
1361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1362: 'ahl.plsql.'||G_PKG_NAME||'.Reopen_Item_Composition', 'Unexpected Error in Reopen_Item_Composition');
1363: END IF;
1364:
1365: WHEN OTHERS THEN
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367: Rollback to Reopen_Item_Composition;
1368: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1369: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1370: p_procedure_name => 'Reopen_Item_Composition',

Line 1375: p_encoded => fnd_api.g_false);

1371: p_error_text => SUBSTR(SQLERRM,1,240));
1372: END IF;
1373: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1374: p_data => x_msg_data,
1375: p_encoded => fnd_api.g_false);
1376:
1377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1378: THEN
1379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1563: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1559: -- Pre-reqs :
1560: -- Parameters :
1561: -- Standard IN Parameters :
1562: -- p_api_version IN NUMBER Required
1563: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1564: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1566: --
1567: -- Standard OUT Parameters :

Line 1564: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1560: -- Parameters :
1561: -- Standard IN Parameters :
1562: -- p_api_version IN NUMBER Required
1563: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1564: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1566: --
1567: -- Standard OUT Parameters :
1568: -- x_return_status OUT VARCHAR2 Required

Line 1565: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1561: -- Standard IN Parameters :
1562: -- p_api_version IN NUMBER Required
1563: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1564: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1565: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1566: --
1567: -- Standard OUT Parameters :
1568: -- x_return_status OUT VARCHAR2 Required
1569: -- x_msg_count OUT NUMBER Required

Line 1580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1576: -- Enhancement 115.10
1577: -- End of Comments --
1578: PROCEDURE Initiate_Item_Comp_Approval (
1579: p_api_version IN NUMBER,
1580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1581: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1583: x_return_status OUT NOCOPY VARCHAR2,
1584: x_msg_count OUT NOCOPY NUMBER,

Line 1581: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1577: -- End of Comments --
1578: PROCEDURE Initiate_Item_Comp_Approval (
1579: p_api_version IN NUMBER,
1580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1581: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1583: x_return_status OUT NOCOPY VARCHAR2,
1584: x_msg_count OUT NOCOPY NUMBER,
1585: x_msg_data OUT NOCOPY VARCHAR2,

Line 1582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1578: PROCEDURE Initiate_Item_Comp_Approval (
1579: p_api_version IN NUMBER,
1580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1581: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1582: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1583: x_return_status OUT NOCOPY VARCHAR2,
1584: x_msg_count OUT NOCOPY NUMBER,
1585: x_msg_data OUT NOCOPY VARCHAR2,
1586: p_Item_Composition_id IN NUMBER,

Line 1609: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

1605: l_msg_count NUMBER;
1606: l_msg_data VARCHAR2(2000);
1607: l_activity_id NUMBER:=p_Item_Composition_id;
1608: l_Status VARCHAR2(1);
1609: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1610: l_object_Version_number NUMBER:=nvl(p_object_Version_number,0);
1611:
1612: l_upd_status VARCHAR2(50);
1613: l_rev_status VARCHAR2(50);

Line 1642: IF FND_API.to_boolean(l_init_msg_list) THEN

1638: SAVEPOINT Initiate_Item_Comp_Approval;
1639:
1640: -- Standard call to check for call compatibility.
1641:
1642: IF FND_API.to_boolean(l_init_msg_list) THEN
1643: FND_MSG_PUB.initialize;
1644: END IF;
1645:
1646: -- Initialize API return status to success

Line 1648: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1644: END IF;
1645:
1646: -- Initialize API return status to success
1647:
1648: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1649:
1650: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1651: THEN
1652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1675: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM

1671: from ahl_item_comp_details
1672: where item_composition_id = p_Item_Composition_id;
1673:
1674:
1675: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM
1676: THEN
1677: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
1678: FND_MSG_PUB.ADD;
1679: END IF;

Line 1681: IF p_Item_Composition_id is null or p_Item_Composition_id = FND_API.G_MISS_NUM

1677: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJ_VERSION_NULL');
1678: FND_MSG_PUB.ADD;
1679: END IF;
1680:
1681: IF p_Item_Composition_id is null or p_Item_Composition_id = FND_API.G_MISS_NUM
1682: THEN
1683: FND_MESSAGE.SET_NAME('AHL','AHL_MC_OBJECT_ID_NULL');
1684: FND_MSG_PUB.ADD;
1685: ELSE

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697: IF l_count < 1 THEN
1698: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_EMPTY');
1699: FND_MESSAGE.Set_Token('ITEM_COMP',l_item_comp_rec.concatenated_segments);
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:
1704:
1705: IF p_approval_type = 'APPROVE'

Line 1727: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1723:
1724: IF l_msg_count > 0
1725: THEN
1726: X_msg_count := l_msg_count;
1727: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730:
1731:

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: IF l_msg_count > 0
1725: THEN
1726: X_msg_count := l_msg_count;
1727: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730:
1731:
1732: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 1748: RAISE FND_API.G_EXC_ERROR;

1744: IF sql%rowcount=0
1745: THEN
1746: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1747: FND_MSG_PUB.ADD;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750:
1751: IF l_ACTIVE='Y'
1752: THEN

Line 1797: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1793:
1794: IF l_msg_count > 0
1795: THEN
1796: X_msg_count := l_msg_count;
1797: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801:

Line 1798: RAISE FND_API.G_EXC_ERROR;

1794: IF l_msg_count > 0
1795: THEN
1796: X_msg_count := l_msg_count;
1797: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801:
1802: -- Standard check of p_commit

Line 1803: IF FND_API.TO_BOOLEAN(p_commit) THEN

1799: END IF;
1800:
1801:
1802: -- Standard check of p_commit
1803: IF FND_API.TO_BOOLEAN(p_commit) THEN
1804: COMMIT WORK;
1805: END IF;
1806:
1807: -- Standard call to get message count and if count is 1, get message info

Line 1811: p_encoded => fnd_api.g_false);

1807: -- Standard call to get message count and if count is 1, get message info
1808: FND_MSG_PUB.Count_And_Get
1809: ( p_count => x_msg_count,
1810: p_data => x_msg_data,
1811: p_encoded => fnd_api.g_false);
1812:
1813: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1814: THEN
1815: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1822: WHEN FND_API.G_EXC_ERROR THEN

1818:
1819:
1820:
1821: EXCEPTION
1822: WHEN FND_API.G_EXC_ERROR THEN
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824: Rollback to Initiate_Item_Comp_Approval;
1825: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1826: p_data => x_msg_data,

Line 1823: x_return_status := FND_API.G_RET_STS_ERROR;

1819:
1820:
1821: EXCEPTION
1822: WHEN FND_API.G_EXC_ERROR THEN
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824: Rollback to Initiate_Item_Comp_Approval;
1825: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1826: p_data => x_msg_data,
1827: p_encoded => fnd_api.g_false);

Line 1827: p_encoded => fnd_api.g_false);

1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824: Rollback to Initiate_Item_Comp_Approval;
1825: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1826: p_data => x_msg_data,
1827: p_encoded => fnd_api.g_false);
1828:
1829: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1830: THEN
1831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1832: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Error in Initiate_Item_Comp_Approval');
1833: END IF;
1834:
1835:
1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838: Rollback to Initiate_Item_Comp_Approval;
1839: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1840: p_data => x_msg_data,

Line 1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1833: END IF;
1834:
1835:
1836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838: Rollback to Initiate_Item_Comp_Approval;
1839: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1840: p_data => x_msg_data,
1841: p_encoded => fnd_api.g_false);

Line 1841: p_encoded => fnd_api.g_false);

1837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1838: Rollback to Initiate_Item_Comp_Approval;
1839: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1840: p_data => x_msg_data,
1841: p_encoded => fnd_api.g_false);
1842:
1843: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1844: THEN
1845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1846: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Unexpected Error in Initiate_Item_Comp_Approval');
1847: END IF;
1848:
1849: WHEN OTHERS THEN
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: Rollback to Initiate_Item_Comp_Approval;
1852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1853: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1854: p_procedure_name => 'Initiate_Item_Comp_Approval',

Line 1859: p_encoded => fnd_api.g_false);

1855: p_error_text => SUBSTR(SQLERRM,1,240));
1856: END IF;
1857: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1858: p_data => x_msg_data,
1859: p_encoded => fnd_api.g_false);
1860:
1861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1862: THEN
1863: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1883: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1879: -- Pre-reqs :
1880: -- Parameters :
1881: -- Standard IN Parameters :
1882: -- p_api_version IN NUMBER Required
1883: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1884: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1885: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1886: --
1887: -- Standard OUT Parameters :

Line 1884: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1880: -- Parameters :
1881: -- Standard IN Parameters :
1882: -- p_api_version IN NUMBER Required
1883: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1884: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1885: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1886: --
1887: -- Standard OUT Parameters :
1888: -- x_return_status OUT VARCHAR2 Required

Line 1885: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1881: -- Standard IN Parameters :
1882: -- p_api_version IN NUMBER Required
1883: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1884: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1885: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1886: --
1887: -- Standard OUT Parameters :
1888: -- x_return_status OUT VARCHAR2 Required
1889: -- x_msg_count OUT NUMBER Required

Line 1900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1896: -- End of Comments --
1897:
1898: PROCEDURE Create_Item_Comp_Revision (
1899: p_api_version IN NUMBER,
1900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1903: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1904: P_MODULE_TYPE IN VARCHAR2,

Line 1901: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1897:
1898: PROCEDURE Create_Item_Comp_Revision (
1899: p_api_version IN NUMBER,
1900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1903: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1904: P_MODULE_TYPE IN VARCHAR2,
1905: x_return_status OUT NOCOPY VARCHAR2,

Line 1902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1898: PROCEDURE Create_Item_Comp_Revision (
1899: p_api_version IN NUMBER,
1900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1903: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1904: P_MODULE_TYPE IN VARCHAR2,
1905: x_return_status OUT NOCOPY VARCHAR2,
1906: x_msg_count OUT NOCOPY NUMBER,

Line 1903: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,

1899: p_api_version IN NUMBER,
1900: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1901: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1902: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1903: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1904: P_MODULE_TYPE IN VARCHAR2,
1905: x_return_status OUT NOCOPY VARCHAR2,
1906: x_msg_count OUT NOCOPY NUMBER,
1907: x_msg_data OUT NOCOPY VARCHAR2,

Line 1937: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

1933: where link_comp_id = c_item_comp_id;
1934:
1935: l_dummy VARCHAR2(1);
1936: l_msg_count Number;
1937: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
1938: l_item_comp_id Number;
1939: l_last_update_login NUMBER;
1940: l_last_updated_by NUMBER;
1941: l_rowid UROWID;

Line 1952: IF FND_API.to_boolean(l_init_msg_list) THEN

1948: SAVEPOINT Create_Item_Comp_Revision;
1949:
1950: -- Standard call to check for call compatibility.
1951:
1952: IF FND_API.to_boolean(l_init_msg_list) THEN
1953: FND_MSG_PUB.initialize;
1954: END IF;
1955:
1956: -- Initialize API return status to success

Line 1958: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1954: END IF;
1955:
1956: -- Initialize API return status to success
1957:
1958: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1959:
1960: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1961: THEN
1962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2007: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2003:
2004: IF l_msg_count > 0
2005: THEN
2006: X_msg_count := l_msg_count;
2007: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;
2010:
2011: -- Sequence Number for the New Revision.

Line 2008: RAISE FND_API.G_EXC_ERROR;

2004: IF l_msg_count > 0
2005: THEN
2006: X_msg_count := l_msg_count;
2007: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;
2010:
2011: -- Sequence Number for the New Revision.
2012:

Line 2190: IF FND_API.TO_BOOLEAN(p_commit) THEN

2186: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'End of Loop');
2187: END IF;
2188:
2189: -- Standard check of p_commit
2190: IF FND_API.TO_BOOLEAN(p_commit) THEN
2191: COMMIT WORK;
2192: END IF;
2193:
2194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 2203: WHEN FND_API.G_EXC_ERROR THEN

2199:
2200:
2201:
2202: EXCEPTION
2203: WHEN FND_API.G_EXC_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: Rollback to Create_Item_Comp_Revision;
2206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2207: p_data => x_msg_data,

Line 2204: x_return_status := FND_API.G_RET_STS_ERROR;

2200:
2201:
2202: EXCEPTION
2203: WHEN FND_API.G_EXC_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: Rollback to Create_Item_Comp_Revision;
2206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2207: p_data => x_msg_data,
2208: p_encoded => fnd_api.g_false);

Line 2208: p_encoded => fnd_api.g_false);

2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: Rollback to Create_Item_Comp_Revision;
2206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2207: p_data => x_msg_data,
2208: p_encoded => fnd_api.g_false);
2209: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2210: THEN
2211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2212: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Error in Create_Item_Comp_Revision');

Line 2216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2212: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Error in Create_Item_Comp_Revision');
2213: END IF;
2214:
2215:
2216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2218: Rollback to Create_Item_Comp_Revision;
2219: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2220: p_data => x_msg_data,

Line 2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2213: END IF;
2214:
2215:
2216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2218: Rollback to Create_Item_Comp_Revision;
2219: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2220: p_data => x_msg_data,
2221: p_encoded => fnd_api.g_false);

Line 2221: p_encoded => fnd_api.g_false);

2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2218: Rollback to Create_Item_Comp_Revision;
2219: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2220: p_data => x_msg_data,
2221: p_encoded => fnd_api.g_false);
2222: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2223: THEN
2224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2225: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unecpected Error in Create_Item_Comp_Revision');

Line 2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2226: END IF;
2227:
2228:
2229: WHEN OTHERS THEN
2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2231: Rollback to Create_Item_Comp_Revision;
2232: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2233: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2234: p_procedure_name => 'Create_Item_Comp_Revision',

Line 2239: p_encoded => fnd_api.g_false);

2235: p_error_text => SUBSTR(SQLERRM,1,240));
2236: END IF;
2237: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2238: p_data => x_msg_data,
2239: p_encoded => fnd_api.g_false);
2240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2241: THEN
2242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2243: 'ahl.plsql.'||G_PKG_NAME||'.Create_Item_Comp_Revision', 'Unknown Error in Create_Item_Comp_Revision');

Line 2265: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

2261: -- Pre-reqs :
2262: -- Parameters :
2263: -- Standard IN Parameters :
2264: -- p_api_version IN NUMBER Required
2265: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2266: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2267: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2268: --
2269: -- Standard OUT Parameters :

Line 2266: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

2262: -- Parameters :
2263: -- Standard IN Parameters :
2264: -- p_api_version IN NUMBER Required
2265: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2266: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2267: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2268: --
2269: -- Standard OUT Parameters :
2270: -- x_return_status OUT VARCHAR2 Required

Line 2267: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

2263: -- Standard IN Parameters :
2264: -- p_api_version IN NUMBER Required
2265: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2266: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2267: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2268: --
2269: -- Standard OUT Parameters :
2270: -- x_return_status OUT VARCHAR2 Required
2271: -- x_msg_count OUT NUMBER Required

Line 2283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2279: -- End of Comments --
2280:
2281: PROCEDURE Approve_Item_Composiiton (
2282: p_api_version IN NUMBER,
2283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
2287: P_MODULE_TYPE IN VARCHAR2,

Line 2284: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2280:
2281: PROCEDURE Approve_Item_Composiiton (
2282: p_api_version IN NUMBER,
2283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
2287: P_MODULE_TYPE IN VARCHAR2,
2288: x_return_status OUT NOCOPY VARCHAR2,

Line 2285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2281: PROCEDURE Approve_Item_Composiiton (
2282: p_api_version IN NUMBER,
2283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
2287: P_MODULE_TYPE IN VARCHAR2,
2288: x_return_status OUT NOCOPY VARCHAR2,
2289: x_msg_count OUT NOCOPY NUMBER,

Line 2286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,

2282: p_api_version IN NUMBER,
2283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
2287: P_MODULE_TYPE IN VARCHAR2,
2288: x_return_status OUT NOCOPY VARCHAR2,
2289: x_msg_count OUT NOCOPY NUMBER,
2290: x_msg_data OUT NOCOPY VARCHAR2,

Line 2325: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

2321: l_object_version_number t_id;
2322:
2323: l_status VARCHAR2(30);
2324: l_msg_count Number;
2325: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
2326: l_rowid urowid;
2327: l_action varchar2(2);
2328:
2329:

Line 2337: IF FND_API.to_boolean(l_init_msg_list) THEN

2333:
2334:
2335: -- Standard call to check for call compatibility.
2336:
2337: IF FND_API.to_boolean(l_init_msg_list) THEN
2338: FND_MSG_PUB.initialize;
2339: END IF;
2340:
2341: -- Initialize API return status to success

Line 2343: x_return_status :=FND_API.G_RET_STS_SUCCESS;

2339: END IF;
2340:
2341: -- Initialize API return status to success
2342:
2343: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2344:
2345: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2346: THEN
2347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2374: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2370:
2371: IF l_msg_count > 0
2372: THEN
2373: X_msg_count := l_msg_count;
2374: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2377:
2378:

Line 2375: RAISE FND_API.G_EXC_ERROR;

2371: IF l_msg_count > 0
2372: THEN
2373: X_msg_count := l_msg_count;
2374: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2377:
2378:
2379: IF p_appr_status='APPROVED'

Line 2532: WHEN FND_API.G_EXC_ERROR THEN

2528:
2529:
2530:
2531: EXCEPTION
2532: WHEN FND_API.G_EXC_ERROR THEN
2533: x_return_status := FND_API.G_RET_STS_ERROR;
2534: Rollback to Approve_Item_Composiiton;
2535: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2536: p_data => x_msg_data,

Line 2533: x_return_status := FND_API.G_RET_STS_ERROR;

2529:
2530:
2531: EXCEPTION
2532: WHEN FND_API.G_EXC_ERROR THEN
2533: x_return_status := FND_API.G_RET_STS_ERROR;
2534: Rollback to Approve_Item_Composiiton;
2535: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2536: p_data => x_msg_data,
2537: p_encoded => fnd_api.g_false);

Line 2537: p_encoded => fnd_api.g_false);

2533: x_return_status := FND_API.G_RET_STS_ERROR;
2534: Rollback to Approve_Item_Composiiton;
2535: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2536: p_data => x_msg_data,
2537: p_encoded => fnd_api.g_false);
2538:
2539: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2540: THEN
2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2542: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Error in Approve_Item_Composiiton');
2543: END IF;
2544:
2545:
2546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: Rollback to Approve_Item_Composiiton;
2549: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2550: p_data => x_msg_data,

Line 2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2543: END IF;
2544:
2545:
2546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: Rollback to Approve_Item_Composiiton;
2549: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2550: p_data => x_msg_data,
2551: p_encoded => fnd_api.g_false);

Line 2551: p_encoded => fnd_api.g_false);

2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: Rollback to Approve_Item_Composiiton;
2549: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2550: p_data => x_msg_data,
2551: p_encoded => fnd_api.g_false);
2552:
2553: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2554: THEN
2555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2556: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Unexpected Error in Approve_Item_Composiiton');
2557: END IF;
2558:
2559: WHEN OTHERS THEN
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2561: Rollback to Approve_Item_Composiiton;
2562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2563: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2564: p_procedure_name => 'Approve_Item_Composiiton',

Line 2569: p_encoded => fnd_api.g_false);

2565: p_error_text => SUBSTR(SQLERRM,1,240));
2566: END IF;
2567: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2568: p_data => x_msg_data,
2569: p_encoded => fnd_api.g_false);
2570:
2571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2572: THEN
2573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,