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_PRD_SERN_CHANGE_PVT dependencies on FND_API

Line 183: IF (p_Serial_Number IS NULL) OR (p_Serial_Number = FND_API.G_MISS_CHAR) THEN

179: -- Validate serial number.(1 = No serial number control; 2 = Pre-defined;
180: -- 3 = Dynamic Entry at inventory receipt.)
181: IF (nvl(p_serial_number_control,0) IN (2,5,6)) THEN
182: -- serial number is mandatory.
183: IF (p_Serial_Number IS NULL) OR (p_Serial_Number = FND_API.G_MISS_CHAR) THEN
184: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NULL');
185: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
186: FND_MSG_PUB.ADD;
187: --dbms_output.put_line('Serial Number is null');

Line 207: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN

203:
204: END IF;
205: ELSE
206: -- if not serialized item, then serial number must be null.
207: IF (p_Serial_Number <> FND_API.G_MISS_CHAR) AND (p_Serial_Number IS NOT NULL) THEN
208: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_NOTNULL');
209: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
210: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
211: FND_MSG_PUB.ADD;

Line 258: p_instance_id = FND_API.G_MISS_NUM) THEN

254: );
255: END IF;
256:
257: IF (p_instance_id IS NULL OR
258: p_instance_id = FND_API.G_MISS_NUM) THEN
259: RETURN NULL;
260: END IF;
261: --
262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 323: p_instance_id = FND_API.G_MISS_NUM THEN

319:
320: BEGIN
321:
322: IF p_instance_id IS NOT NULL AND
323: p_instance_id = FND_API.G_MISS_NUM THEN
324: RETURN NULL;
325: END IF;
326: --
327: OPEN Csi_Iea_Value_Cur(p_instance_id);

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

354: -- Parameters :
355: --
356: -- Standard IN Parameters :
357: -- p_api_version IN NUMBER Required
358: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
359: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
360: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
361: -- Based on this flag, the API will set the default attributes.
362: -- p_module_type In VARCHAR2 Default NULL

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

355: --
356: -- Standard IN Parameters :
357: -- p_api_version IN NUMBER Required
358: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
359: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
360: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
361: -- Based on this flag, the API will set the default attributes.
362: -- p_module_type In VARCHAR2 Default NULL
363: -- This will be null.

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

356: -- Standard IN Parameters :
357: -- p_api_version IN NUMBER Required
358: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
359: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
360: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
361: -- Based on this flag, the API will set the default attributes.
362: -- p_module_type In VARCHAR2 Default NULL
363: -- This will be null.
364: -- Standard OUT Parameters :

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

373: -- List of Serial number change attributes
374:
375: PROCEDURE Process_Serialnum_Change (
376: p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: p_commit IN VARCHAR2 := FND_API.G_FALSE,
379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380: p_serialnum_change_rec IN Sernum_Change_Rec_Type,
381: x_return_status OUT NOCOPY VARCHAR2,

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

374:
375: PROCEDURE Process_Serialnum_Change (
376: p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: p_commit IN VARCHAR2 := FND_API.G_FALSE,
379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380: p_serialnum_change_rec IN Sernum_Change_Rec_Type,
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,

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

375: PROCEDURE Process_Serialnum_Change (
376: p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
378: p_commit IN VARCHAR2 := FND_API.G_FALSE,
379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380: p_serialnum_change_rec IN Sernum_Change_Rec_Type,
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2,

Line 585: IF FND_API.to_boolean(p_init_msg_list)

581:
582: ------------------------------------------------
583: -- Standard call to check for call compatibility.
584: ------------------------------------------------
585: IF FND_API.to_boolean(p_init_msg_list)
586: THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589:
590: -------------------------------------------
591: -- Initialize API return status to success
592: -------------------------------------------
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: ------------------------------------------------------------
596: -- Initialize message list if p_init_msg_list is set to TRUE.
597: ------------------------------------------------------------

Line 598: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

594:
595: ------------------------------------------------------------
596: -- Initialize message list if p_init_msg_list is set to TRUE.
597: ------------------------------------------------------------
598: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
599: p_api_version,
600: l_api_name,G_PKG_NAME)
601: THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
599: p_api_version,
600: l_api_name,G_PKG_NAME)
601: THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: --------------------Start of API Body-----------------------------------
606:

Line 672: RAISE FND_API.G_EXC_ERROR;

668: )
669: THEN
670: FND_MESSAGE.Set_Name('AHL','AHL_COM_REQD_PARAM_MISSING');
671: FND_MSG_PUB.ADD;
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674:
675: -- Arunjk added to check if the data has been modified of not BUG NO : 12658658
676: L_MODIFIED_FLAG := FALSE;

Line 690: RAISE FND_API.G_EXC_ERROR;

686: IF(L_MODIFIED_FLAG = FALSE) THEN
687: IF(VALUES_MODIFIED_CHK.OLD_LOT_NUM = L_SERIALNUM_CHANGE_REC.NEW_LOT_NUMBER OR (VALUES_MODIFIED_CHK.OLD_LOT_NUM IS NULL AND L_SERIALNUM_CHANGE_REC.NEW_LOT_NUMBER IS NULL)) THEN
688: FND_MESSAGE.Set_Name('AHL','AHL_COM_NO_CHANGES_TO_SAVE');
689: FND_MSG_PUB.ADD;
690: RAISE FND_API.G_EXC_ERROR;
691: END IF;
692: END IF;
693: END IF;
694: END IF;

Line 743: p_init_msg_list => FND_API.G_FALSE,

739:
740: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
741: (
742: p_api_version => 1.0,
743: p_init_msg_list => FND_API.G_FALSE,
744: p_commit => FND_API.G_FALSE,
745: p_serialnum_change_rec => l_osp_serialnum_change_rec,
746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,

Line 744: p_commit => FND_API.G_FALSE,

740: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
741: (
742: p_api_version => 1.0,
743: p_init_msg_list => FND_API.G_FALSE,
744: p_commit => FND_API.G_FALSE,
745: p_serialnum_change_rec => l_osp_serialnum_change_rec,
746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data

Line 762: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

758: );
759:
760: END IF;
761:
762: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;

Line 763: RAISE FND_API.G_EXC_ERROR;

759:
760: END IF;
761:
762: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:

Line 764: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

760: END IF;
761:
762: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: ELSE --If the osp_line_id is null, then the the change is being performed from a workorder

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761:
762: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: ELSE --If the osp_line_id is null, then the the change is being performed from a workorder
769:

Line 794: RAISE FND_API.G_EXC_ERROR;

790: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_MISSING');
791: FND_MESSAGE.Set_Token('JOBNUMBER',l_serialnum_change_rec.job_number);
792: FND_MSG_PUB.ADD;
793: CLOSE get_workorder_csr;
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: CLOSE get_workorder_csr;
797:
798: -- rroy

Line 804: IF l_return_status = FND_API.G_TRUE THEN

800: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_get_workorder_rec.workorder_id,
801: p_ue_id => NULL,
802: p_visit_id => NULL,
803: p_item_instance_id => NULL);
804: IF l_return_status = FND_API.G_TRUE THEN
805: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_SNC_UNTLCKD');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;

Line 807: RAISE FND_API.G_EXC_ERROR;

803: p_item_instance_id => NULL);
804: IF l_return_status = FND_API.G_TRUE THEN
805: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_SNC_UNTLCKD');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809:
810: -- rroy
811: -- ACL Changes

Line 833: RAISE FND_API.G_EXC_ERROR;

829: --l_inventory_item_id := l_new_inventory_item_id;
830: ELSE
831: FND_MESSAGE.Set_Name('AHL','AHL_PP_INV_ID_REQUIRED');
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835:
836: -------------------------------------------------------------------------------------
837: -- retrieve all instance related details and performe related validations

Line 848: RAISE FND_API.G_EXC_ERROR;

844: IF l_instance_dtls_rec.instance_id IS NULL
845: THEN
846: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
847: FND_MSG_PUB.ADD;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850:
851: --Adithya added the location_type_code check to allow PN/SN change for the top node
852: -- Bug# 6683990

Line 864: RAISE FND_API.G_EXC_ERROR;

860: IF (l_instance_dtls_rec.location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY'))
861: THEN
862: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_LOC_INVALID');
863: FND_MSG_PUB.ADD;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: END IF;
867:
868: --l_inventory_item_id := NVL(l_new_inventory_item_id,l_instance_dtls_rec.inventory_item_id);

Line 886: RAISE FND_API.G_EXC_ERROR;

882: THEN
883: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CHG_ITEM_INVALID');
884: -- Source or Destination item should be serial controlled.
885: FND_MSG_PUB.ADD;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: END IF;
889:
890: -- Adithya added the following validation to check whether the new item is valid for the position

Line 900: IF l_matches_flag = FND_API.G_FALSE

896: AHL_UTIL_UC_PKG.Item_Matches_Instance_Pos(p_inventory_item_id => l_inventory_item_id,
897: p_item_revision => l_serialnum_change_rec.new_item_rev_number,
898: p_instance_id => l_serialnum_change_rec.instance_id,
899: x_matches_flag => l_matches_flag);
900: IF l_matches_flag = FND_API.G_FALSE
901: THEN
902: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');
903: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);
904: FND_MSG_PUB.ADD;

Line 905: RAISE FND_API.G_EXC_ERROR;

901: THEN
902: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');
903: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);
904: FND_MSG_PUB.ADD;
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908: --Adithya changes end
909: --------------------------------------------

Line 916: (l_serialnum_change_rec.New_Serial_Tag_Code = FND_API.G_MISS_CHAR)

912: --------------------------------------------
913: IF
914: (l_serialnum_change_rec.New_Serial_Tag_Code IS NULL)
915: OR
916: (l_serialnum_change_rec.New_Serial_Tag_Code = FND_API.G_MISS_CHAR)
917: THEN
918: -- Check if meaning exists.
919: IF (l_serialnum_change_rec.New_Serial_Tag_Mean IS NOT NULL)
920: AND

Line 921: (l_serialnum_change_rec.New_Serial_Tag_Mean <> FND_API.G_MISS_CHAR)

917: THEN
918: -- Check if meaning exists.
919: IF (l_serialnum_change_rec.New_Serial_Tag_Mean IS NOT NULL)
920: AND
921: (l_serialnum_change_rec.New_Serial_Tag_Mean <> FND_API.G_MISS_CHAR)
922: THEN
923: Convert_To_LookupCode('AHL_SERIALNUMBER_TAG',
924: l_serialnum_change_rec.New_Serial_Tag_Mean,
925: l_lookup_code,

Line 931: RAISE FND_API.G_EXC_ERROR;

927: IF NOT(l_return_val) THEN
928: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
929: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
930: FND_MSG_PUB.ADD;
931: RAISE FND_API.G_EXC_ERROR;
932: ELSE
933: l_serialnum_change_rec.New_Serial_Tag_Code := l_lookup_code;
934: END IF;
935: END IF;

Line 959: X_return_status := Fnd_Api.G_RET_STS_ERROR;

955: l_msg_count := Fnd_Msg_Pub.count_msg;
956:
957: IF l_msg_count > 0 THEN
958: X_msg_count := l_msg_count;
959: X_return_status := Fnd_Api.G_RET_STS_ERROR;
960: RAISE Fnd_Api.G_EXC_ERROR;
961: END IF;
962:
963: ----------------------

Line 960: RAISE Fnd_Api.G_EXC_ERROR;

956:
957: IF l_msg_count > 0 THEN
958: X_msg_count := l_msg_count;
959: X_return_status := Fnd_Api.G_RET_STS_ERROR;
960: RAISE Fnd_Api.G_EXC_ERROR;
961: END IF;
962:
963: ----------------------
964: -- Check for UC Exists

Line 994: l_serialnum_change_rec.New_Serial_Tag_Code <> FND_API.G_MISS_CHAR AND

990: IF (l_serial_tag_rec_found = 'Y' ) THEN
991: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NULL AND l_serial_tag_code IS NOT NULL) OR
992: (l_serial_tag_code IS NULL AND l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) OR
993: (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL AND l_Serial_tag_code IS NOT NULL AND
994: l_serialnum_change_rec.New_Serial_Tag_Code <> FND_API.G_MISS_CHAR AND
995: l_serialnum_change_rec.New_Serial_Tag_Code <> l_Serial_tag_code) THEN
996:
997: -- changed value. update attribute record.
998: l_csi_extend_attrib_rec.attribute_value_id := l_attribute_value_id;

Line 1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1045: -- GetCSI_Transaction_ID('UC_UPDATE',l_transaction_type_id, l_return_val);
1046: -- Balaji modified the transaction id type to 205--ITEM_SERIAL_CHANGE
1047: GetCSI_Transaction_ID('ITEM_SERIAL_CHANGE',l_transaction_type_id, l_return_val);
1048: IF NOT(l_return_val) THEN
1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1050: END IF;
1051:
1052: -- ??use the transaction id from the header record.
1053:

Line 1087: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1083: x_return_status => l_return_status,
1084: x_msg_count => l_msg_count,
1085: x_msg_data => l_msg_data );
1086:
1087: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1088: RAISE FND_API.G_EXC_ERROR;
1089: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: END IF;

Line 1088: RAISE FND_API.G_EXC_ERROR;

1084: x_msg_count => l_msg_count,
1085: x_msg_data => l_msg_data );
1086:
1087: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1088: RAISE FND_API.G_EXC_ERROR;
1089: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: END IF;
1092:

Line 1089: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1085: x_msg_data => l_msg_data );
1086:
1087: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1088: RAISE FND_API.G_EXC_ERROR;
1089: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: END IF;
1092:
1093: -------------------------------------------------------------

Line 1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1086:
1087: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1088: RAISE FND_API.G_EXC_ERROR;
1089: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: END IF;
1092:
1093: -------------------------------------------------------------
1094: -- for extended attributes.

Line 1107: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1103: x_msg_count => l_msg_count,
1104: x_msg_data => l_msg_data );
1105:
1106:
1107: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1108: RAISE FND_API.G_EXC_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;

Line 1108: RAISE FND_API.G_EXC_ERROR;

1104: x_msg_data => l_msg_data );
1105:
1106:
1107: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1108: RAISE FND_API.G_EXC_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112: END IF;

Line 1109: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1105:
1106:
1107: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1108: RAISE FND_API.G_EXC_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112: END IF;
1113:

Line 1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1106:
1107: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1108: RAISE FND_API.G_EXC_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112: END IF;
1113:
1114: --Adithya added the following validation to verify that the UC rules are not broken

Line 1125: p_init_msg_list => FND_API.G_FALSE,

1121: END IF;
1122:
1123: ahl_uc_validation_pub.Validate_Completeness(
1124: p_api_version => 1.0,
1125: p_init_msg_list => FND_API.G_FALSE,
1126: p_commit => FND_API.G_FALSE,
1127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1128: x_return_status => l_return_status,
1129: x_msg_count => l_msg_count,

Line 1126: p_commit => FND_API.G_FALSE,

1122:
1123: ahl_uc_validation_pub.Validate_Completeness(
1124: p_api_version => 1.0,
1125: p_init_msg_list => FND_API.G_FALSE,
1126: p_commit => FND_API.G_FALSE,
1127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1128: x_return_status => l_return_status,
1129: x_msg_count => l_msg_count,
1130: x_msg_data => l_msg_data,

Line 1127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1123: ahl_uc_validation_pub.Validate_Completeness(
1124: p_api_version => 1.0,
1125: p_init_msg_list => FND_API.G_FALSE,
1126: p_commit => FND_API.G_FALSE,
1127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1128: x_return_status => l_return_status,
1129: x_msg_count => l_msg_count,
1130: x_msg_data => l_msg_data,
1131: p_unit_header_id => l_root_uc_header_id,

Line 1134: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1130: x_msg_data => l_msg_data,
1131: p_unit_header_id => l_root_uc_header_id,
1132: x_error_tbl => x_warning_msg_tbl);
1133:
1134: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: p_unit_header_id => l_root_uc_header_id,
1132: x_error_tbl => x_warning_msg_tbl);
1133:
1134: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139: END IF;

Line 1136: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1132: x_error_tbl => x_warning_msg_tbl);
1133:
1134: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139: END IF;
1140: --Adithya changes end

Line 1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1133:
1134: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139: END IF;
1140: --Adithya changes end
1141:

Line 1152: p_init_msg_list => FND_API.G_TRUE ,

1148: FOR GET_SRC_RES_ID_REC IN GET_SRC_RES_ID_CSR(l_serialnum_change_rec.workorder_id)
1149: LOOP
1150: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION (
1151: p_api_version => 1.0,
1152: p_init_msg_list => FND_API.G_TRUE ,
1153: p_commit => FND_API.G_FALSE ,
1154: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1155: p_module_type => NULL,
1156: x_return_status => l_return_status ,

Line 1153: p_commit => FND_API.G_FALSE ,

1149: LOOP
1150: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION (
1151: p_api_version => 1.0,
1152: p_init_msg_list => FND_API.G_TRUE ,
1153: p_commit => FND_API.G_FALSE ,
1154: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1155: p_module_type => NULL,
1156: x_return_status => l_return_status ,
1157: x_msg_count => l_msg_count ,

Line 1154: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

1150: AHL_MM_RESERVATIONS_PVT.DELETE_RESERVATION (
1151: p_api_version => 1.0,
1152: p_init_msg_list => FND_API.G_TRUE ,
1153: p_commit => FND_API.G_FALSE ,
1154: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1155: p_module_type => NULL,
1156: x_return_status => l_return_status ,
1157: x_msg_count => l_msg_count ,
1158: x_msg_data => l_msg_data ,

Line 1161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1157: x_msg_count => l_msg_count ,
1158: x_msg_data => l_msg_data ,
1159: p_reservation_id => GET_SRC_RES_ID_REC.RESERVATION_ID);
1160: -- Check return status.
1161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1162: IF ( G_DEBUG = 'Y' ) THEN
1163: AHL_DEBUG_PUB.debug('Delete_Reservation failed for Reservation ID: '
1164: || GET_SRC_RES_ID_REC.RESERVATION_ID);
1165: END IF; -- G_DEBUG.

Line 1170: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1166:
1167: EXIT;
1168: END IF; -- l_return_status
1169: END LOOP;
1170: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;

Line 1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1167: EXIT;
1168: END IF; -- l_return_status
1169: END LOOP;
1170: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: end if; -- ARUNJK Changes End

Line 1172: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1168: END IF; -- l_return_status
1169: END LOOP;
1170: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: end if; -- ARUNJK Changes End
1176: ------------------------End of Body---------------------------------------

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169: END LOOP;
1170: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: end if; -- ARUNJK Changes End
1176: ------------------------End of Body---------------------------------------
1177:

Line 1184: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1180:
1181: /*
1182: IF l_msg_count > 0 THEN
1183: X_msg_count := l_msg_count;
1184: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1185: RAISE Fnd_Api.G_EXC_ERROR;
1186: END IF;
1187: */
1188:

Line 1185: RAISE Fnd_Api.G_EXC_ERROR;

1181: /*
1182: IF l_msg_count > 0 THEN
1183: X_msg_count := l_msg_count;
1184: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1185: RAISE Fnd_Api.G_EXC_ERROR;
1186: END IF;
1187: */
1188:
1189: --Standard check for commit

Line 1190: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1186: END IF;
1187: */
1188:
1189: --Standard check for commit
1190: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1191: COMMIT;
1192: END IF;
1193:
1194: -- Debug info

Line 1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1198: Ahl_Debug_Pub.disable_debug;
1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO Process_Serialnum_Change;
1204: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,

Line 1204: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO Process_Serialnum_Change;
1204: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208: IF G_DEBUG='Y' THEN

Line 1205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1201: EXCEPTION
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: ROLLBACK TO Process_Serialnum_Change;
1204: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208: IF G_DEBUG='Y' THEN
1209: AHL_DEBUG_PUB.log_app_messages (

Line 1216: WHEN FND_API.G_EXC_ERROR THEN

1212: -- Check if API is called in debug mode. If yes, disable debug.
1213: AHL_DEBUG_PUB.disable_debug;
1214: END IF;
1215:
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: ROLLBACK TO Process_Serialnum_Change;
1218: X_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,

Line 1218: X_return_status := FND_API.G_RET_STS_ERROR;

1214: END IF;
1215:
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: ROLLBACK TO Process_Serialnum_Change;
1218: X_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,
1221: p_data => X_msg_data);
1222: IF G_DEBUG='Y' THEN

Line 1219: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1215:
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: ROLLBACK TO Process_Serialnum_Change;
1218: X_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,
1221: p_data => X_msg_data);
1222: IF G_DEBUG='Y' THEN
1223: -- Debug info.

Line 1232: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1228: AHL_DEBUG_PUB.disable_debug;
1229: END IF;
1230: WHEN OTHERS THEN
1231: ROLLBACK TO Process_Serialnum_Change;
1232: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1234: THEN
1235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_SERN_CHANGE_PVT',
1236: p_procedure_name => 'PROCESS_SERIALNUM_CHANGE',

Line 1239: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_SERN_CHANGE_PVT',
1236: p_procedure_name => 'PROCESS_SERIALNUM_CHANGE',
1237: p_error_text => SUBSTR(SQLERRM,1,240));
1238: END IF;
1239: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => X_msg_data);
1242: IF G_DEBUG='Y' THEN
1243: -- Debug info.