DBA Data[Home] [Help]

APPS.EAM_ASSETNUMBER_PUB dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

360: p_maintenance_object_type => 3
361: );
362:
363: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
364: FND_MESSAGE.SET_NAME('EAM', 'EAM_INSTANTIATE_OBJECT_FAILED');
365: FND_MSG_PUB.Add;
366: RAISE FND_API.G_EXC_ERROR;
367: end if;
368: end if;

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

611: );
612:
613: if (not l_validate) then
614: --add_error(l_reason_failed);
615: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
616: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
617: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
618: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
619: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

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

613: if (not l_validate) then
614: --add_error(l_reason_failed);
615: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
616: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
617: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
618: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
619: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
620: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
621: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);

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

615: FND_MESSAGE.SET_NAME('EAM', l_reason_failed);
616: if (l_reason_failed='EAM_INVALID_DESC_FLEX') then
617: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
618: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
619: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
620: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
621: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
622: end if;
623: FND_MSG_PUB.Add;

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

617: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_token);
618: elsif (l_reason_failed = 'EAM_REB_NETWORK_INVALID') then
619: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
620: elsif (l_reason_failed = 'EAM_REB_INVALID_PN_LOC') then
621: FND_MESSAGE.SET_TOKEN('ASSET',l_rebuild_meaning);
622: end if;
623: FND_MSG_PUB.Add;
624: RAISE FND_API.G_EXC_ERROR;
625: end if;

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

631: WHERE linear_location_id = p_eam_linear_id
632: AND instance_id <> l_instance_id AND ROWNUM = 1;
633:
634: IF (l_count > 0) THEN
635: FND_MESSAGE.SET_NAME('EAM', 'EAM_LINEAR_ID_EXISTS_IN_MSN');
636: FND_MSG_PUB.Add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639: END IF;

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

653: null;
654: end;
655:
656: if (l_old_current_status = 3) then
657: FND_MESSAGE.SET_NAME('EAM','EAM_ASSET_IN_INVENTORY');
658: FND_MSG_PUB.Add;
659: RAISE FND_API.G_EXC_ERROR;
660: end if;
661: end if;

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

856: l_validate:=eam_common_utilities_pvt.validate_boolean_flag
857: (p_maintainable_flag);
858: if (not l_validate) then
859: x_reason_failed:='EAM_MAINTAINABLE_FLAG_INVALID';
860: fnd_message.set_name('EAM',x_reason_failed);
861: fnd_msg_pub.add;
862: return false;
863: end if;
864:

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

882: AND wewr.maintenance_object_id = l_instance_id
883: AND wewr.maintenance_object_type = 3);
884: IF l_count = 1 then
885: x_reason_failed:='EAM_WO_EXIST';
886: fnd_message.set_name('EAM',x_reason_failed);
887: fnd_msg_pub.add;
888: return false;
889: END IF;
890: EXCEPTION

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

901: l_validate:=eam_common_utilities_pvt.validate_boolean_flag
902: (p_network_asset_flag);
903: if ( (not l_validate) or (p_network_asset_flag <> l_old_network_asset_flag) ) then
904: x_reason_failed:='EAM_NETWORK_ASSET_INVALID';
905: fnd_message.set_name('EAM',x_reason_failed);
906: fnd_msg_pub.add;
907: return false;
908: end if;
909: else

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

921: (p_EAM_LINEAR_ID);
922:
923: if (not l_validate) then
924: x_reason_failed:='EAM_INVALID_EAM_LINEAR_ID';
925: fnd_message.set_name('EAM',x_reason_failed);
926: fnd_msg_pub.add;
927: return false;
928: end if;
929: end if;

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

940: (p_owning_department_id,
941: p_current_organization_id);
942: if (not l_validate) then
943: x_reason_failed:='EAM_DEPT_ID_INVALID';
944: fnd_message.set_name('EAM',x_reason_failed);
945: fnd_msg_pub.add;
946: return false;
947: end if;
948: end if;

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

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

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

966: ('MTL_EAM_ASSET_CRITICALITY',
967: p_asset_criticality_code);
968: if (not l_validate) then
969: x_reason_failed:='EAM_ASSET_CRITICALITY_INVALID';
970: fnd_message.set_name('EAM',x_reason_failed);
971: fnd_msg_pub.add;
972: return false;
973: end if;
974: end if;

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

979: (p_current_organization_id,
980: p_eam_location_id);
981: if (not l_validate) then
982: x_reason_failed:='EAM_LOCATION_ID_INVALID';
983: fnd_message.set_name('EAM',x_reason_failed);
984: fnd_msg_pub.add;
985: return false;
986: end if;
987: end if;

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

1000: l_validate:=(l_count>0);
1001:
1002: if (not l_validate) then
1003: x_reason_failed:='EAM_CATEGORY_ID_INVALID';
1004: fnd_message.set_name('EAM',x_reason_failed);
1005: fnd_msg_pub.add;
1006: return false;
1007: end if;
1008: end if;

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

1015: where application_id=140;
1016:
1017: if (l_count = 0) then
1018: x_reason_failed:='EAM_FA_ASSET_ID_INVALID';
1019: fnd_message.set_name('EAM',x_reason_failed);
1020: fnd_msg_pub.add;
1021: return false;
1022: else
1023: SELECT count(*) into l_count

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

1026:
1027: l_validate:=(l_count>0);
1028: if (not l_validate) then
1029: x_reason_failed:='EAM_FA_ASSET_ID_INVALID';
1030: fnd_message.set_name('EAM',x_reason_failed);
1031: fnd_msg_pub.add;
1032: return false;
1033: end if;
1034: end if;

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

1044: where application_id=240;
1045:
1046: if (l_count = 0) then
1047: x_reason_failed:='EAM_PN_LOCATION_ID_INVALID';
1048: fnd_message.set_name('EAM',x_reason_failed);
1049: fnd_msg_pub.add;
1050: return false;
1051: else
1052: SELECT count(*) into l_count

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

1055:
1056: l_validate:=(l_count>0);
1057: if (not l_validate) then
1058: x_reason_failed:='EAM_PN_LOCATION_ID_INVALID';
1059: fnd_message.set_name('EAM',x_reason_failed);
1060: fnd_msg_pub.add;
1061: return false;
1062: end if;
1063: end if;

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

1082: if (not (
1083: (p_equipment_item_id is not null) and
1084: (p_eqp_serial_number is not null))) then
1085: x_reason_failed:='EAM_PROD_EQP_INCOMPLETE';
1086: fnd_message.set_name('EAM',x_reason_failed);
1087: fnd_msg_pub.add;
1088: return false;
1089: end if;
1090: end if;

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

1117: and maint_organization_id=p_current_organization_id;
1118:
1119: if (l_count=0) then
1120: x_reason_failed:='EAM_INVALID_PROD_ORG';
1121: fnd_message.set_name('EAM',x_reason_failed);
1122: fnd_msg_pub.add;
1123: return false;
1124: end if;
1125: end if;

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

1130: WHERE inventory_item_id = l_prod_inventory_item_id
1131: AND organization_id = l_prod_organization_id;
1132: if (l_count = 0) then
1133: x_reason_failed:='EAM_INVALID_EQP_ITEM';
1134: fnd_message.set_name('EAM',x_reason_failed);
1135: fnd_msg_pub.add;
1136: return false;
1137: end if;
1138:

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

1143: AND organization_id = l_prod_organization_id;
1144:
1145: if (l_prod_equipment_type is null) then
1146: x_reason_failed:='EAM_EQP_INVALID';
1147: fnd_message.set_name('EAM',x_reason_failed);
1148: fnd_msg_pub.add;
1149: return false;
1150: else
1151: IF l_prod_equipment_type <> 1 -- not equipment type

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

1150: else
1151: IF l_prod_equipment_type <> 1 -- not equipment type
1152: THEN
1153: x_reason_failed:='EAM_EQP_WRONG_TYPE';
1154: fnd_message.set_name('EAM',x_reason_failed);
1155: fnd_msg_pub.add;
1156: return false;
1157: END IF;
1158: end if;

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

1166: and serial_number = l_prod_serial_number;
1167:
1168: if l_count = 0 then
1169: x_reason_failed:='EAM_EQP_SERIAL_INVALID';
1170: fnd_message.set_name('EAM',x_reason_failed);
1171: fnd_msg_pub.add;
1172: return false;
1173: end if;
1174: end if;

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

1179: ('EAM_ASSET_OPERATION_TXN_TYPE',
1180: p_checkin_status);
1181: if ( (not l_validate) or (p_network_asset_flag = 'Y') ) then
1182: x_reason_failed:='EAM_CHECKIN_STATUS_INVALID';
1183: fnd_message.set_name('EAM',x_reason_failed);
1184: fnd_msg_pub.add;
1185: return false;
1186: end if;
1187:

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

1190: if (p_operational_log_flag is not null and p_operational_log_flag <> fnd_api.g_miss_char) then
1191: if ((nvl(p_operational_log_flag,'N') not in ('Y','N')) or
1192: (p_network_asset_flag = 'Y' and p_operational_log_flag = 'Y') ) then
1193: x_reason_failed:='EAM_OPERATION_LOG_FLAG_INVALID';
1194: fnd_message.set_name('EAM',x_reason_failed);
1195: fnd_msg_pub.add;
1196: return false;
1197: end if;
1198:

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

1205:
1206: procedure add_error (p_error_code IN varchar2)
1207: is
1208: begin
1209: FND_MESSAGE.SET_NAME('EAM', p_error_code);
1210: FND_MSG_PUB.Add;
1211: end;
1212:
1213: