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 556: IF FND_API.to_boolean(p_init_msg_list)

552:
553: ------------------------------------------------
554: -- Standard call to check for call compatibility.
555: ------------------------------------------------
556: IF FND_API.to_boolean(p_init_msg_list)
557: THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560:
561: -------------------------------------------
562: -- Initialize API return status to success
563: -------------------------------------------
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: ------------------------------------------------------------
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: ------------------------------------------------------------

Line 569: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

565:
566: ------------------------------------------------------------
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: ------------------------------------------------------------
569: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
570: p_api_version,
571: l_api_name,G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
570: p_api_version,
571: l_api_name,G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576: --------------------Start of API Body-----------------------------------
577:

Line 643: RAISE FND_API.G_EXC_ERROR;

639: )
640: THEN
641: FND_MESSAGE.Set_Name('AHL','AHL_COM_REQD_PARAM_MISSING');
642: FND_MSG_PUB.ADD;
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645:
646: IF(l_serialnum_change_rec.OSP_LINE_ID IS NOT NULL) THEN
647:

Line 686: p_init_msg_list => FND_API.G_FALSE,

682:
683: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
684: (
685: p_api_version => 1.0,
686: p_init_msg_list => FND_API.G_FALSE,
687: p_commit => FND_API.G_FALSE,
688: p_serialnum_change_rec => l_osp_serialnum_change_rec,
689: x_return_status => l_return_status,
690: x_msg_count => l_msg_count,

Line 687: p_commit => FND_API.G_FALSE,

683: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
684: (
685: p_api_version => 1.0,
686: p_init_msg_list => FND_API.G_FALSE,
687: p_commit => FND_API.G_FALSE,
688: p_serialnum_change_rec => l_osp_serialnum_change_rec,
689: x_return_status => l_return_status,
690: x_msg_count => l_msg_count,
691: x_msg_data => l_msg_data

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

701: );
702:
703: END IF;
704:
705: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
706: RAISE FND_API.G_EXC_ERROR;
707: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
709: END IF;

Line 706: RAISE FND_API.G_EXC_ERROR;

702:
703: END IF;
704:
705: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
706: RAISE FND_API.G_EXC_ERROR;
707: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
709: END IF;
710:

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

703: END IF;
704:
705: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
706: RAISE FND_API.G_EXC_ERROR;
707: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
709: END IF;
710:
711: ELSE --If the osp_line_id is null, then the the change is being performed from a workorder

Line 708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

704:
705: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
706: RAISE FND_API.G_EXC_ERROR;
707: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
709: END IF;
710:
711: ELSE --If the osp_line_id is null, then the the change is being performed from a workorder
712:

Line 737: RAISE FND_API.G_EXC_ERROR;

733: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_MISSING');
734: FND_MESSAGE.Set_Token('JOBNUMBER',l_serialnum_change_rec.job_number);
735: FND_MSG_PUB.ADD;
736: CLOSE get_workorder_csr;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739: CLOSE get_workorder_csr;
740:
741: -- rroy

Line 747: IF l_return_status = FND_API.G_TRUE THEN

743: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_get_workorder_rec.workorder_id,
744: p_ue_id => NULL,
745: p_visit_id => NULL,
746: p_item_instance_id => NULL);
747: IF l_return_status = FND_API.G_TRUE THEN
748: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_SNC_UNTLCKD');
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;

Line 750: RAISE FND_API.G_EXC_ERROR;

746: p_item_instance_id => NULL);
747: IF l_return_status = FND_API.G_TRUE THEN
748: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_SNC_UNTLCKD');
749: FND_MSG_PUB.ADD;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752:
753: -- rroy
754: -- ACL Changes

Line 776: RAISE FND_API.G_EXC_ERROR;

772: --l_inventory_item_id := l_new_inventory_item_id;
773: ELSE
774: FND_MESSAGE.Set_Name('AHL','AHL_PP_INV_ID_REQUIRED');
775: FND_MSG_PUB.ADD;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778:
779: -------------------------------------------------------------------------------------
780: -- retrieve all instance related details and performe related validations

Line 791: RAISE FND_API.G_EXC_ERROR;

787: IF l_instance_dtls_rec.instance_id IS NULL
788: THEN
789: FND_MESSAGE.Set_Name('AHL','AHL_INVALID_INSTANCE');
790: FND_MSG_PUB.ADD;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: --Adithya added the location_type_code check to allow PN/SN change for the top node
795: -- Bug# 6683990

Line 807: RAISE FND_API.G_EXC_ERROR;

803: IF (l_instance_dtls_rec.location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY'))
804: THEN
805: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_LOC_INVALID');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: END IF;
810:
811: --l_inventory_item_id := NVL(l_new_inventory_item_id,l_instance_dtls_rec.inventory_item_id);

Line 829: RAISE FND_API.G_EXC_ERROR;

825: THEN
826: FND_MESSAGE.Set_Name('AHL','AHL_PRD_CHG_ITEM_INVALID');
827: -- Source or Destination item should be serial controlled.
828: FND_MSG_PUB.ADD;
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831: END IF;
832:
833: -- Adithya added the following validation to check whether the new item is valid for the position

Line 843: IF l_matches_flag = FND_API.G_FALSE

839: AHL_UTIL_UC_PKG.Item_Matches_Instance_Pos(p_inventory_item_id => l_inventory_item_id,
840: p_item_revision => l_serialnum_change_rec.new_item_rev_number,
841: p_instance_id => l_serialnum_change_rec.instance_id,
842: x_matches_flag => l_matches_flag);
843: IF l_matches_flag = FND_API.G_FALSE
844: THEN
845: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');
846: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);
847: FND_MSG_PUB.ADD;

Line 848: RAISE FND_API.G_EXC_ERROR;

844: THEN
845: FND_MESSAGE.Set_Name('AHL','AHL_PRD_ITEM_POS_MISMATCH');
846: FND_MESSAGE.Set_Token('ITEM',l_serialnum_change_rec.NEW_ITEM_NUMBER);
847: FND_MSG_PUB.ADD;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: END IF;
851: --Adithya changes end
852: --------------------------------------------

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

855: --------------------------------------------
856: IF
857: (l_serialnum_change_rec.New_Serial_Tag_Code IS NULL)
858: OR
859: (l_serialnum_change_rec.New_Serial_Tag_Code = FND_API.G_MISS_CHAR)
860: THEN
861: -- Check if meaning exists.
862: IF (l_serialnum_change_rec.New_Serial_Tag_Mean IS NOT NULL)
863: AND

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

860: THEN
861: -- Check if meaning exists.
862: IF (l_serialnum_change_rec.New_Serial_Tag_Mean IS NOT NULL)
863: AND
864: (l_serialnum_change_rec.New_Serial_Tag_Mean <> FND_API.G_MISS_CHAR)
865: THEN
866: Convert_To_LookupCode('AHL_SERIALNUMBER_TAG',
867: l_serialnum_change_rec.New_Serial_Tag_Mean,
868: l_lookup_code,

Line 874: RAISE FND_API.G_EXC_ERROR;

870: IF NOT(l_return_val) THEN
871: FND_MESSAGE.Set_Name('AHL','AHL_PRD_TAGMEANING_INVALID');
872: FND_MESSAGE.Set_Token('TAG',l_serialnum_change_rec.New_Serial_Tag_Mean);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_ERROR;
875: ELSE
876: l_serialnum_change_rec.New_Serial_Tag_Code := l_lookup_code;
877: END IF;
878: END IF;

Line 902: X_return_status := Fnd_Api.G_RET_STS_ERROR;

898: l_msg_count := Fnd_Msg_Pub.count_msg;
899:
900: IF l_msg_count > 0 THEN
901: X_msg_count := l_msg_count;
902: X_return_status := Fnd_Api.G_RET_STS_ERROR;
903: RAISE Fnd_Api.G_EXC_ERROR;
904: END IF;
905:
906: ----------------------

Line 903: RAISE Fnd_Api.G_EXC_ERROR;

899:
900: IF l_msg_count > 0 THEN
901: X_msg_count := l_msg_count;
902: X_return_status := Fnd_Api.G_RET_STS_ERROR;
903: RAISE Fnd_Api.G_EXC_ERROR;
904: END IF;
905:
906: ----------------------
907: -- Check for UC Exists

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

933: IF (l_serial_tag_rec_found = 'Y' ) THEN
934: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NULL AND l_serial_tag_code IS NOT NULL) OR
935: (l_serial_tag_code IS NULL AND l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) OR
936: (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL AND l_Serial_tag_code IS NOT NULL AND
937: l_serialnum_change_rec.New_Serial_Tag_Code <> FND_API.G_MISS_CHAR AND
938: l_serialnum_change_rec.New_Serial_Tag_Code <> l_Serial_tag_code) THEN
939:
940: -- changed value. update attribute record.
941: l_csi_extend_attrib_rec.attribute_value_id := l_attribute_value_id;

Line 992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

988: -- GetCSI_Transaction_ID('UC_UPDATE',l_transaction_type_id, l_return_val);
989: -- Balaji modified the transaction id type to 205--ITEM_SERIAL_CHANGE
990: GetCSI_Transaction_ID('ITEM_SERIAL_CHANGE',l_transaction_type_id, l_return_val);
991: IF NOT(l_return_val) THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF;
994:
995: -- ??use the transaction id from the header record.
996:

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

1026: x_return_status => l_return_status,
1027: x_msg_count => l_msg_count,
1028: x_msg_data => l_msg_data );
1029:
1030: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1031: RAISE FND_API.G_EXC_ERROR;
1032: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1034: END IF;

Line 1031: RAISE FND_API.G_EXC_ERROR;

1027: x_msg_count => l_msg_count,
1028: x_msg_data => l_msg_data );
1029:
1030: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1031: RAISE FND_API.G_EXC_ERROR;
1032: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1034: END IF;
1035:

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

1028: x_msg_data => l_msg_data );
1029:
1030: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1031: RAISE FND_API.G_EXC_ERROR;
1032: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1034: END IF;
1035:
1036: -------------------------------------------------------------

Line 1033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1029:
1030: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1031: RAISE FND_API.G_EXC_ERROR;
1032: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1034: END IF;
1035:
1036: -------------------------------------------------------------
1037: -- for extended attributes.

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

1046: x_msg_count => l_msg_count,
1047: x_msg_data => l_msg_data );
1048:
1049:
1050: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;

Line 1051: RAISE FND_API.G_EXC_ERROR;

1047: x_msg_data => l_msg_data );
1048:
1049:
1050: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055: END IF;

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

1048:
1049:
1050: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055: END IF;
1056:

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1049:
1050: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055: END IF;
1056:
1057: --Adithya added the following validation to verify that the UC rules are not broken

Line 1068: p_init_msg_list => FND_API.G_FALSE,

1064: END IF;
1065:
1066: ahl_uc_validation_pub.Validate_Completeness(
1067: p_api_version => 1.0,
1068: p_init_msg_list => FND_API.G_FALSE,
1069: p_commit => FND_API.G_FALSE,
1070: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1071: x_return_status => l_return_status,
1072: x_msg_count => l_msg_count,

Line 1069: p_commit => FND_API.G_FALSE,

1065:
1066: ahl_uc_validation_pub.Validate_Completeness(
1067: p_api_version => 1.0,
1068: p_init_msg_list => FND_API.G_FALSE,
1069: p_commit => FND_API.G_FALSE,
1070: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1071: x_return_status => l_return_status,
1072: x_msg_count => l_msg_count,
1073: x_msg_data => l_msg_data,

Line 1070: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1066: ahl_uc_validation_pub.Validate_Completeness(
1067: p_api_version => 1.0,
1068: p_init_msg_list => FND_API.G_FALSE,
1069: p_commit => FND_API.G_FALSE,
1070: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1071: x_return_status => l_return_status,
1072: x_msg_count => l_msg_count,
1073: x_msg_data => l_msg_data,
1074: p_unit_header_id => l_root_uc_header_id,

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

1073: x_msg_data => l_msg_data,
1074: p_unit_header_id => l_root_uc_header_id,
1075: x_error_tbl => x_warning_msg_tbl);
1076:
1077: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1078: RAISE FND_API.G_EXC_ERROR;
1079: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074: p_unit_header_id => l_root_uc_header_id,
1075: x_error_tbl => x_warning_msg_tbl);
1076:
1077: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1078: RAISE FND_API.G_EXC_ERROR;
1079: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;
1082: END IF;

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

1075: x_error_tbl => x_warning_msg_tbl);
1076:
1077: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1078: RAISE FND_API.G_EXC_ERROR;
1079: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;
1082: END IF;
1083: --Adithya changes end

Line 1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1076:
1077: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1078: RAISE FND_API.G_EXC_ERROR;
1079: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: END IF;
1082: END IF;
1083: --Adithya changes end
1084:

Line 1095: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1091:
1092: /*
1093: IF l_msg_count > 0 THEN
1094: X_msg_count := l_msg_count;
1095: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1096: RAISE Fnd_Api.G_EXC_ERROR;
1097: END IF;
1098: */
1099:

Line 1096: RAISE Fnd_Api.G_EXC_ERROR;

1092: /*
1093: IF l_msg_count > 0 THEN
1094: X_msg_count := l_msg_count;
1095: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1096: RAISE Fnd_Api.G_EXC_ERROR;
1097: END IF;
1098: */
1099:
1100: --Standard check for commit

Line 1101: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1097: END IF;
1098: */
1099:
1100: --Standard check for commit
1101: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1102: COMMIT;
1103: END IF;
1104:
1105: -- Debug info

Line 1113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1109: Ahl_Debug_Pub.disable_debug;
1110: END IF;
1111:
1112: EXCEPTION
1113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1114: ROLLBACK TO Process_Serialnum_Change;
1115: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1117: p_count => x_msg_count,

Line 1115: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1111:
1112: EXCEPTION
1113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1114: ROLLBACK TO Process_Serialnum_Change;
1115: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data);
1119: IF G_DEBUG='Y' THEN

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

1112: EXCEPTION
1113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1114: ROLLBACK TO Process_Serialnum_Change;
1115: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data);
1119: IF G_DEBUG='Y' THEN
1120: AHL_DEBUG_PUB.log_app_messages (

Line 1127: WHEN FND_API.G_EXC_ERROR THEN

1123: -- Check if API is called in debug mode. If yes, disable debug.
1124: AHL_DEBUG_PUB.disable_debug;
1125: END IF;
1126:
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: ROLLBACK TO Process_Serialnum_Change;
1129: X_return_status := FND_API.G_RET_STS_ERROR;
1130: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1131: p_count => x_msg_count,

Line 1129: X_return_status := FND_API.G_RET_STS_ERROR;

1125: END IF;
1126:
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: ROLLBACK TO Process_Serialnum_Change;
1129: X_return_status := FND_API.G_RET_STS_ERROR;
1130: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1131: p_count => x_msg_count,
1132: p_data => X_msg_data);
1133: IF G_DEBUG='Y' THEN

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

1126:
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: ROLLBACK TO Process_Serialnum_Change;
1129: X_return_status := FND_API.G_RET_STS_ERROR;
1130: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1131: p_count => x_msg_count,
1132: p_data => X_msg_data);
1133: IF G_DEBUG='Y' THEN
1134: -- Debug info.

Line 1143: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1139: AHL_DEBUG_PUB.disable_debug;
1140: END IF;
1141: WHEN OTHERS THEN
1142: ROLLBACK TO Process_Serialnum_Change;
1143: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_SERN_CHANGE_PVT',
1147: p_procedure_name => 'PROCESS_SERIALNUM_CHANGE',

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

1146: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_SERN_CHANGE_PVT',
1147: p_procedure_name => 'PROCESS_SERIALNUM_CHANGE',
1148: p_error_text => SUBSTR(SQLERRM,1,240));
1149: END IF;
1150: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => X_msg_data);
1153: IF G_DEBUG='Y' THEN
1154: -- Debug info.