DBA Data[Home] [Help]

APPS.EAM_ASSETNUMBER_PUB dependencies on FND_MESSAGE

Line 187: fnd_message.set_name('EAM','EAM_SER_UNIQ2');

183: );
184:
185: if l_return_status <> 'S' then
186: if (l_validate = TRUE) then
187: fnd_message.set_name('EAM','EAM_SER_UNIQ2');
188: fnd_message.set_token('NAME',p_serial_number);
189: fnd_msg_pub.add;
190: raise FND_API.G_EXC_ERROR;
191: else

Line 188: fnd_message.set_token('NAME',p_serial_number);

184:
185: if l_return_status <> 'S' then
186: if (l_validate = TRUE) then
187: fnd_message.set_name('EAM','EAM_SER_UNIQ2');
188: fnd_message.set_token('NAME',p_serial_number);
189: fnd_msg_pub.add;
190: raise FND_API.G_EXC_ERROR;
191: else
192: fnd_message.set_name('EAM','EAM_SER_UNIQ1');

Line 192: fnd_message.set_name('EAM','EAM_SER_UNIQ1');

188: fnd_message.set_token('NAME',p_serial_number);
189: fnd_msg_pub.add;
190: raise FND_API.G_EXC_ERROR;
191: else
192: fnd_message.set_name('EAM','EAM_SER_UNIQ1');
193: fnd_message.set_token('NAME',p_serial_number);
194: fnd_msg_pub.add;
195: raise FND_API.G_EXC_ERROR;
196: end if;

Line 193: fnd_message.set_token('NAME',p_serial_number);

189: fnd_msg_pub.add;
190: raise FND_API.G_EXC_ERROR;
191: else
192: fnd_message.set_name('EAM','EAM_SER_UNIQ1');
193: fnd_message.set_token('NAME',p_serial_number);
194: fnd_msg_pub.add;
195: raise FND_API.G_EXC_ERROR;
196: end if;
197: end if;

Line 250: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);

246: x_token => l_token
247: );
248:
249: if (not l_validate) then
250: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
251: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
252: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
253: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
254: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

Line 252: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);

248:
249: if (not l_validate) then
250: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
251: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
252: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
253: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
254: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
255: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
256: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

Line 254: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

250: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
251: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
252: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
253: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
254: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
255: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
256: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
257: end if;
258: FND_MSG_PUB.Add;

Line 256: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

252: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
253: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
254: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
255: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
256: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
257: end if;
258: FND_MSG_PUB.Add;
259: RAISE FND_API.G_EXC_ERROR;
260: end if;

Line 270: FND_MESSAGE.SET_NAME('EAM', 'EAM_LINEAR_ID_EXISTS_IN_MSN');

266: SELECT count(*) INTO l_count FROM csi_item_instances
267: WHERE linear_location_id = p_eam_linear_id AND ROWNUM = 1;
268:
269: IF (l_count > 0) THEN
270: FND_MESSAGE.SET_NAME('EAM', 'EAM_LINEAR_ID_EXISTS_IN_MSN');
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: END IF;

Line 382: FND_MESSAGE.SET_NAME('EAM', 'EAM_INSTANTIATE_OBJECT_FAILED');

378: p_maintenance_object_type => 3
379: );
380:
381: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
382: FND_MESSAGE.SET_NAME('EAM', 'EAM_INSTANTIATE_OBJECT_FAILED');
383: FND_MSG_PUB.Add;
384: RAISE FND_API.G_EXC_ERROR;
385: end if;
386: end if;

Line 635: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);

631: );
632:
633: if (not l_validate) then
634: --add_error(l_reason_failed);
635: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
636: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
637: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
638: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
639: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

Line 637: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);

633: if (not l_validate) then
634: --add_error(l_reason_failed);
635: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
636: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
637: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
638: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
639: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
640: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
641: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

Line 639: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

635: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
636: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
637: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
638: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
639: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
640: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
641: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
642: end if;
643: FND_MSG_PUB.Add;

Line 641: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

637: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
638: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
639: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
640: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
641: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
642: end if;
643: FND_MSG_PUB.Add;
644: RAISE FND_API.G_EXC_ERROR;
645: end if;

Line 655: FND_MESSAGE.SET_NAME('EAM', 'EAM_LINEAR_ID_EXISTS_IN_MSN');

651: WHERE linear_location_id = p_eam_linear_id
652: AND instance_id <> l_instance_id AND ROWNUM = 1;
653:
654: IF (l_count > 0) THEN
655: FND_MESSAGE.SET_NAME('EAM', 'EAM_LINEAR_ID_EXISTS_IN_MSN');
656: FND_MSG_PUB.Add;
657: RAISE FND_API.G_EXC_ERROR;
658: END IF;
659: END IF;

Line 677: FND_MESSAGE.SET_NAME('EAM','EAM_ASSET_IN_INVENTORY');

673: null;
674: end;
675:
676: if (l_old_current_status = 3) then
677: FND_MESSAGE.SET_NAME('EAM','EAM_ASSET_IN_INVENTORY');
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: end if;
681: end if;

Line 892: fnd_message.set_name('EAM',x_reason_failed);

888: l_validate:=eam_common_utilities_pvt.validate_boolean_flag
889: (p_maintainable_flag);
890: if (not l_validate) then
891: x_reason_failed:='EAM_MAINTAINABLE_FLAG_INVALID';
892: fnd_message.set_name('EAM',x_reason_failed);
893: fnd_msg_pub.add;
894: return false;
895: end if;
896:

Line 918: fnd_message.set_name('EAM',x_reason_failed);

914: AND wewr.maintenance_object_id = l_instance_id
915: AND wewr.maintenance_object_type = 3);
916: IF l_count = 1 then
917: x_reason_failed:='EAM_WO_EXIST';
918: fnd_message.set_name('EAM',x_reason_failed);
919: fnd_msg_pub.add;
920: return false;
921: END IF;
922: EXCEPTION

Line 937: fnd_message.set_name('EAM',x_reason_failed);

933: l_validate:=eam_common_utilities_pvt.validate_boolean_flag
934: (p_network_asset_flag);
935: if ( (not l_validate) or (p_network_asset_flag <> l_old_network_asset_flag) ) then
936: x_reason_failed:='EAM_NETWORK_ASSET_INVALID';
937: fnd_message.set_name('EAM',x_reason_failed);
938: fnd_msg_pub.add;
939: return false;
940: end if;
941: else

Line 957: fnd_message.set_name('EAM',x_reason_failed);

953: (p_EAM_LINEAR_ID);
954:
955: if (not l_validate) then
956: x_reason_failed:='EAM_INVALID_EAM_LINEAR_ID';
957: fnd_message.set_name('EAM',x_reason_failed);
958: fnd_msg_pub.add;
959: return false;
960: end if;
961: end if;

Line 976: fnd_message.set_name('EAM',x_reason_failed);

972: (p_owning_department_id,
973: p_current_organization_id);
974: if (not l_validate) then
975: x_reason_failed:='EAM_DEPT_ID_INVALID';
976: fnd_message.set_name('EAM',x_reason_failed);
977: fnd_msg_pub.add;
978: return false;
979: end if;
980: end if;

Line 989: fnd_message.set_name('EAM',x_reason_failed);

985: (p_current_organization_id,
986: p_wip_accounting_class_code);
987: if (not l_validate) then
988: x_reason_failed:='EAM_WIP_ACCT_CLASS_INVALID';
989: fnd_message.set_name('EAM',x_reason_failed);
990: fnd_msg_pub.add;
991: return false;
992: end if;
993: end if;

Line 1002: fnd_message.set_name('EAM',x_reason_failed);

998: ('MTL_EAM_ASSET_CRITICALITY',
999: p_asset_criticality_code);
1000: if (not l_validate) then
1001: x_reason_failed:='EAM_ASSET_CRITICALITY_INVALID';
1002: fnd_message.set_name('EAM',x_reason_failed);
1003: fnd_msg_pub.add;
1004: return false;
1005: end if;
1006: end if;

Line 1015: fnd_message.set_name('EAM',x_reason_failed);

1011: (p_current_organization_id,
1012: p_eam_location_id);
1013: if (not l_validate) then
1014: x_reason_failed:='EAM_LOCATION_ID_INVALID';
1015: fnd_message.set_name('EAM',x_reason_failed);
1016: fnd_msg_pub.add;
1017: return false;
1018: end if;
1019: end if;

Line 1036: fnd_message.set_name('EAM',x_reason_failed);

1032: l_validate:=(l_count>0);
1033:
1034: if (not l_validate) then
1035: x_reason_failed:='EAM_CATEGORY_ID_INVALID';
1036: fnd_message.set_name('EAM',x_reason_failed);
1037: fnd_msg_pub.add;
1038: return false;
1039: end if;
1040: end if;

Line 1051: fnd_message.set_name('EAM',x_reason_failed);

1047: where application_id=140;
1048:
1049: if (l_count = 0) then
1050: x_reason_failed:='EAM_FA_ASSET_ID_INVALID';
1051: fnd_message.set_name('EAM',x_reason_failed);
1052: fnd_msg_pub.add;
1053: return false;
1054: else
1055: SELECT count(*) into l_count

Line 1062: fnd_message.set_name('EAM',x_reason_failed);

1058:
1059: l_validate:=(l_count>0);
1060: if (not l_validate) then
1061: x_reason_failed:='EAM_FA_ASSET_ID_INVALID';
1062: fnd_message.set_name('EAM',x_reason_failed);
1063: fnd_msg_pub.add;
1064: return false;
1065: end if;
1066: end if;

Line 1080: fnd_message.set_name('EAM',x_reason_failed);

1076: where application_id=240;
1077:
1078: if (l_count = 0) then
1079: x_reason_failed:='EAM_PN_LOCATION_ID_INVALID';
1080: fnd_message.set_name('EAM',x_reason_failed);
1081: fnd_msg_pub.add;
1082: return false;
1083: else
1084: SELECT count(*) into l_count

Line 1091: fnd_message.set_name('EAM',x_reason_failed);

1087:
1088: l_validate:=(l_count>0);
1089: if (not l_validate) then
1090: x_reason_failed:='EAM_PN_LOCATION_ID_INVALID';
1091: fnd_message.set_name('EAM',x_reason_failed);
1092: fnd_msg_pub.add;
1093: return false;
1094: end if;
1095: end if;

Line 1118: fnd_message.set_name('EAM',x_reason_failed);

1114: if (not (
1115: (p_equipment_item_id is not null) and
1116: (p_eqp_serial_number is not null))) then
1117: x_reason_failed:='EAM_PROD_EQP_INCOMPLETE';
1118: fnd_message.set_name('EAM',x_reason_failed);
1119: fnd_msg_pub.add;
1120: return false;
1121: end if;
1122: end if;

Line 1153: fnd_message.set_name('EAM',x_reason_failed);

1149: and maint_organization_id=p_current_organization_id;
1150:
1151: if (l_count=0) then
1152: x_reason_failed:='EAM_INVALID_PROD_ORG';
1153: fnd_message.set_name('EAM',x_reason_failed);
1154: fnd_msg_pub.add;
1155: return false;
1156: end if;
1157: end if;

Line 1166: fnd_message.set_name('EAM',x_reason_failed);

1162: WHERE inventory_item_id = l_prod_inventory_item_id
1163: AND organization_id = l_prod_organization_id;
1164: if (l_count = 0) then
1165: x_reason_failed:='EAM_INVALID_EQP_ITEM';
1166: fnd_message.set_name('EAM',x_reason_failed);
1167: fnd_msg_pub.add;
1168: return false;
1169: end if;
1170:

Line 1179: fnd_message.set_name('EAM',x_reason_failed);

1175: AND organization_id = l_prod_organization_id;
1176:
1177: if (l_prod_equipment_type is null) then
1178: x_reason_failed:='EAM_EQP_INVALID';
1179: fnd_message.set_name('EAM',x_reason_failed);
1180: fnd_msg_pub.add;
1181: return false;
1182: else
1183: IF l_prod_equipment_type <> 1 -- not equipment type

Line 1186: fnd_message.set_name('EAM',x_reason_failed);

1182: else
1183: IF l_prod_equipment_type <> 1 -- not equipment type
1184: THEN
1185: x_reason_failed:='EAM_EQP_WRONG_TYPE';
1186: fnd_message.set_name('EAM',x_reason_failed);
1187: fnd_msg_pub.add;
1188: return false;
1189: END IF;
1190: end if;

Line 1202: fnd_message.set_name('EAM',x_reason_failed);

1198: and serial_number = l_prod_serial_number;
1199:
1200: if l_count = 0 then
1201: x_reason_failed:='EAM_EQP_SERIAL_INVALID';
1202: fnd_message.set_name('EAM',x_reason_failed);
1203: fnd_msg_pub.add;
1204: return false;
1205: end if;
1206: end if;

Line 1215: fnd_message.set_name('EAM',x_reason_failed);

1211: ('EAM_ASSET_OPERATION_TXN_TYPE',
1212: p_checkin_status);
1213: if ( (not l_validate) or (p_network_asset_flag = 'Y') ) then
1214: x_reason_failed:='EAM_CHECKIN_STATUS_INVALID';
1215: fnd_message.set_name('EAM',x_reason_failed);
1216: fnd_msg_pub.add;
1217: return false;
1218: end if;
1219:

Line 1226: fnd_message.set_name('EAM',x_reason_failed);

1222: if (p_operational_log_flag is not null and p_operational_log_flag <> fnd_api.g_miss_char) then
1223: if ((nvl(p_operational_log_flag,'N') not in ('Y','N')) or
1224: (p_network_asset_flag = 'Y' and p_operational_log_flag = 'Y') ) then
1225: x_reason_failed:='EAM_OPERATION_LOG_FLAG_INVALID';
1226: fnd_message.set_name('EAM',x_reason_failed);
1227: fnd_msg_pub.add;
1228: return false;
1229: end if;
1230:

Line 1241: FND_MESSAGE.SET_NAME('EAM', p_error_code);

1237:
1238: procedure add_error (p_error_code IN varchar2)
1239: is
1240: begin
1241: FND_MESSAGE.SET_NAME('EAM', p_error_code);
1242: FND_MSG_PUB.Add;
1243: end;
1244:
1245: