143: BEGIN
144:
145:
146: FND_MESSAGE.SET_NAME ('EAM', ERROR);
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: END;
150:
151:
158: BEGIN
159: if p_application_id is null or p_application_id <> 401
160: then
161: fnd_message.set_name('EAM', 'EAM_INVALID_APPLICATION_ID');
162: fnd_msg_pub.add;
163: RAISE fnd_api.g_exc_error;
164: end if;
165: END;
166:
184:
185:
186: if l_count = 0 then
187: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_ID');
188: fnd_msg_pub.add;
189: RAISE fnd_api.g_exc_error;
190: end if;
191:
192: END;
208: and descriptive_flex_context_code=p_attribute_category;
209:
210: if l_count = 0 then
211: fnd_message.set_name('EAM', 'EAM_INVALID_ASSOCIATION_GROUP');
212: fnd_msg_pub.add;
213: RAISE fnd_api.g_exc_error;
214: end if;
215: END;
216:
242:
243: if l_count = 0
244: then
245: fnd_message.set_name('EAM', 'EAM_AAV_INVALID_DFF_CONTEXT');
246: fnd_msg_pub.add;
247: RAISE fnd_api.g_exc_error;
248: end if;
249:
250: END ;
354: l_error_segments:=FND_FLEX_DESCVAL.error_segment;
355: l_error_message:= substr(fnd_flex_descval.error_message,1,4000);
356: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
357: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_error_message);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361:
362: end validate_dff_segments;
384: then
385: if NOT p_create_flag
386: then
387: fnd_message.set_name('EAM', 'EAM_ATTR_VALUES_REC_NOT_FOUND');
388: fnd_msg_pub.add;
389: RAISE fnd_api.g_exc_error;
390: END IF;
391: else
392: if p_create_flag
391: else
392: if p_create_flag
393: then
394: fnd_message.set_name('EAM', 'EAM_ATTR_VALUES_REC_EXISTS');
395: fnd_msg_pub.add;
396: RAISE fnd_api.g_exc_error;
397: END IF;
398: end if;
399: END;
498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
499: END IF;
500: -- Initialize message list if p_init_msg_list is set to TRUE.
501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504: -- Initialize API return status to success
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506: -- API body
509: l_org_id := P_ORGANIZATION_ID;
510: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
511: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
512: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
513: fnd_msg_pub.add;
514: RAISE fnd_api.g_exc_error;
515: else
516:
517: l_creation_organization_id := P_ORGANIZATION_ID;
531: x_msg_data => l_msg_data);
532: if l_boolean = 0
533: then
534: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
535: fnd_msg_pub.add;
536: RAISE fnd_api.g_exc_error;
537: end if;
538: end if;
539:
541:
542: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
543: (p_inventory_item_id is null or p_serial_number is null)) THEN
544: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
545: fnd_msg_pub.add;
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548:
549: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
547: END IF;
548:
549: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
550: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
551: fnd_msg_pub.add;
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554:
555: l_maintenance_object_type := p_maintenance_object_type;
746: l_item_type
747: )
748: THEN
749: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
750: fnd_msg_pub.add;
751: RAISE fnd_api.g_exc_error;
752: END IF;
753: */
754:
901: IF FND_API.To_Boolean( p_commit ) THEN
902: COMMIT WORK;
903: END IF;
904: -- Standard call to get message count and if count is 1, get message info.
905: FND_MSG_PUB.get
906: ( p_msg_index_out => x_msg_count ,
907: p_data => x_msg_data
908: );
909: EXCEPTION
909: EXCEPTION
910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO insert_assetattr_value;
912: x_return_status := FND_API.G_RET_STS_ERROR ;
913: FND_MSG_PUB.get
914: ( p_msg_index_out => x_msg_count ,
915: p_data => x_msg_data
916: );
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: );
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO insert_assetattr_value;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.get
921: ( p_msg_index_out => x_msg_count ,
922: p_data => x_msg_data
923: );
924: WHEN OTHERS THEN
923: );
924: WHEN OTHERS THEN
925: ROLLBACK TO insert_assetattr_value;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: IF FND_MSG_PUB.Check_Msg_Level
928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: FND_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
924: WHEN OTHERS THEN
925: ROLLBACK TO insert_assetattr_value;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: IF FND_MSG_PUB.Check_Msg_Level
928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: FND_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
932: l_api_name
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: IF FND_MSG_PUB.Check_Msg_Level
928: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: FND_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
932: l_api_name
933: );
934: END IF;
931: ( G_PKG_NAME ,
932: l_api_name
933: );
934: END IF;
935: FND_MSG_PUB.get
936: ( p_msg_index_out => x_msg_count ,
937: p_data => x_msg_data
938: );
939: END insert_assetattr_value;
1033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1034: END IF;
1035: -- Initialize message list if p_init_msg_list is set to TRUE.
1036: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039: -- Initialize API return status to success
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041: -- API body
1043: l_org_id := P_ORGANIZATION_ID;
1044: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
1045: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
1046: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
1047: fnd_msg_pub.add;
1048: RAISE fnd_api.g_exc_error;
1049: else
1050:
1051: l_creation_organization_id := P_ORGANIZATION_ID;
1065: x_msg_data => l_msg_data);
1066: if l_boolean = 0
1067: then
1068: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1069: fnd_msg_pub.add;
1070: RAISE fnd_api.g_exc_error;
1071: end if;
1072: end if;
1073:
1076:
1077: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
1078: (p_inventory_item_id is null or p_serial_number is null)) THEN
1079: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
1080: fnd_msg_pub.add;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
1082: END IF;
1083:
1084: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
1085: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
1086: fnd_msg_pub.add;
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089:
1090: l_maintenance_object_type := p_maintenance_object_type;
1358: IF FND_API.To_Boolean( p_commit ) THEN
1359: COMMIT WORK;
1360: END IF;
1361: -- Standard call to get message count and if count is 1, get message info.
1362: FND_MSG_PUB.get
1363: ( p_msg_index_out => x_msg_count ,
1364: p_data => x_msg_data
1365: );
1366: EXCEPTION
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN
1368: ROLLBACK TO update_assetattr_value;
1369: x_return_status := FND_API.G_RET_STS_ERROR ;
1370: FND_MSG_PUB.get
1371: ( p_msg_index_out => x_msg_count ,
1372: p_data => x_msg_data
1373: );
1374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1373: );
1374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1375: ROLLBACK TO update_assetattr_value;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1377: FND_MSG_PUB.get
1378: ( p_msg_index_out => x_msg_count ,
1379: p_data => x_msg_data
1380: );
1381: WHEN OTHERS THEN
1380: );
1381: WHEN OTHERS THEN
1382: ROLLBACK TO update_assetattr_value;
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1384: IF FND_MSG_PUB.Check_Msg_Level
1385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1386: THEN
1387: FND_MSG_PUB.Add_Exc_Msg
1388: ( G_PKG_NAME ,
1381: WHEN OTHERS THEN
1382: ROLLBACK TO update_assetattr_value;
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1384: IF FND_MSG_PUB.Check_Msg_Level
1385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1386: THEN
1387: FND_MSG_PUB.Add_Exc_Msg
1388: ( G_PKG_NAME ,
1389: l_api_name
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1384: IF FND_MSG_PUB.Check_Msg_Level
1385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1386: THEN
1387: FND_MSG_PUB.Add_Exc_Msg
1388: ( G_PKG_NAME ,
1389: l_api_name
1390: );
1391: END IF;
1388: ( G_PKG_NAME ,
1389: l_api_name
1390: );
1391: END IF;
1392: FND_MSG_PUB.get
1393: ( p_msg_index_out => x_msg_count ,
1394: p_data => x_msg_data
1395: );
1396: END update_assetattr_value;