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.EAM_ASSETNUMBER_PUB dependencies on FND_MSG_PUB

Line 116: FND_MSG_PUB.initialize;

112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114: -- Initialize message list if p_init_msg_list is set to TRUE.
115: IF FND_API.to_Boolean( p_init_msg_list ) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118: -- Initialize API return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: -- API body

Line 189: fnd_msg_pub.add;

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');
193: fnd_message.set_token('NAME',p_serial_number);

Line 194: 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;
198:

Line 258: FND_MSG_PUB.Add;

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;
261:
262: -- Bug # 4770445 : Need to check if p_eam_linear_id is null or not

Line 271: FND_MSG_PUB.Add;

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;
275:

Line 383: FND_MSG_PUB.Add;

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;
387:

Line 394: FND_MSG_PUB.Count_And_Get

390: IF FND_API.To_Boolean( p_commit ) THEN
391: COMMIT WORK;
392: END IF;
393: -- Standard call to get message count and if count is 1, get message info.
394: FND_MSG_PUB.Count_And_Get
395: ( p_count => x_msg_count ,
396: p_data => x_msg_data
397: );
398: EXCEPTION

Line 402: FND_MSG_PUB.Count_And_Get

398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: ROLLBACK TO Insert_Asset_Number_Pub;
401: x_return_status := FND_API.G_RET_STS_ERROR ;
402: FND_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count ,
404: p_data => x_msg_data
405: );
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 409: FND_MSG_PUB.Count_And_Get

405: );
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ROLLBACK TO Insert_Asset_Number_Pub;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409: FND_MSG_PUB.Count_And_Get
410: ( p_count => x_msg_count ,
411: p_data => x_msg_data
412: );
413: WHEN OTHERS THEN

Line 416: IF FND_MSG_PUB.Check_Msg_Level

412: );
413: WHEN OTHERS THEN
414: ROLLBACK TO Insert_Asset_Number_Pub;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: IF FND_MSG_PUB.Check_Msg_Level
417: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
418: THEN
419: FND_MSG_PUB.Add_Exc_Msg
420: ( G_PKG_NAME ,

Line 417: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

413: WHEN OTHERS THEN
414: ROLLBACK TO Insert_Asset_Number_Pub;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: IF FND_MSG_PUB.Check_Msg_Level
417: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
418: THEN
419: FND_MSG_PUB.Add_Exc_Msg
420: ( G_PKG_NAME ,
421: l_api_name

Line 419: FND_MSG_PUB.Add_Exc_Msg

415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: IF FND_MSG_PUB.Check_Msg_Level
417: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
418: THEN
419: FND_MSG_PUB.Add_Exc_Msg
420: ( G_PKG_NAME ,
421: l_api_name
422: );
423: END IF;

Line 424: FND_MSG_PUB.Count_And_Get

420: ( G_PKG_NAME ,
421: l_api_name
422: );
423: END IF;
424: FND_MSG_PUB.Count_And_Get
425: ( p_count => x_msg_count ,
426: p_data => x_msg_data
427: );
428: END Insert_Asset_Number;

Line 536: FND_MSG_PUB.initialize;

532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534: -- Initialize message list if p_init_msg_list is set to TRUE.
535: IF FND_API.to_Boolean( p_init_msg_list ) THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538: -- Initialize API return status to success
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540: -- API body

Line 643: FND_MSG_PUB.Add;

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;
646:
647: -- Bug # 4770445 : Need to check if p_eam_linear_id is null or not

Line 656: FND_MSG_PUB.Add;

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;
660:

Line 678: FND_MSG_PUB.Add;

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;
682:

Line 769: FND_MSG_PUB.Count_And_Get

765: IF FND_API.To_Boolean( p_commit ) THEN
766: COMMIT WORK;
767: END IF;
768: -- Standard call to get message count and if count is 1, get message info.
769: FND_MSG_PUB.Count_And_Get
770: ( p_count => x_msg_count ,
771: p_data => x_msg_data
772: );
773: EXCEPTION

Line 777: FND_MSG_PUB.Count_And_Get

773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: ROLLBACK TO Update_Asset_Number_Pub;
776: x_return_status := FND_API.G_RET_STS_ERROR ;
777: FND_MSG_PUB.Count_And_Get
778: ( p_count => x_msg_count ,
779: p_data => x_msg_data
780: );
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 784: FND_MSG_PUB.Count_And_Get

780: );
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: ROLLBACK TO Update_Asset_Number_Pub;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
784: FND_MSG_PUB.Count_And_Get
785: ( p_count => x_msg_count ,
786: p_data => x_msg_data
787: );
788: WHEN OTHERS THEN

Line 791: IF FND_MSG_PUB.Check_Msg_Level

787: );
788: WHEN OTHERS THEN
789: ROLLBACK TO Update_Asset_Number_Pub;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg
795: ( G_PKG_NAME ,

Line 792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

788: WHEN OTHERS THEN
789: ROLLBACK TO Update_Asset_Number_Pub;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg
795: ( G_PKG_NAME ,
796: l_api_name

Line 794: FND_MSG_PUB.Add_Exc_Msg

790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: IF FND_MSG_PUB.Check_Msg_Level
792: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
793: THEN
794: FND_MSG_PUB.Add_Exc_Msg
795: ( G_PKG_NAME ,
796: l_api_name
797: );
798: END IF;

Line 799: FND_MSG_PUB.Count_And_Get

795: ( G_PKG_NAME ,
796: l_api_name
797: );
798: END IF;
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count ,
801: p_data => x_msg_data
802: );
803: END Update_Asset_Number;

Line 893: fnd_msg_pub.add;

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:
897: /* Bug # 4768635 : Validate if Maintainable)_flag can be 'N' */

Line 919: fnd_msg_pub.add;

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
923: WHEN NO_DATA_FOUND THEN

Line 938: fnd_msg_pub.add;

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
942: if (p_network_asset_flag = 'Y') then

Line 958: fnd_msg_pub.add;

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;
962:

Line 977: fnd_msg_pub.add;

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;
981:

Line 990: fnd_msg_pub.add;

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;
994:

Line 1003: fnd_msg_pub.add;

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;
1007:

Line 1016: fnd_msg_pub.add;

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;
1020:

Line 1037: fnd_msg_pub.add;

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;
1041:

Line 1052: fnd_msg_pub.add;

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
1056: FROM FA_ADDITIONS_B

Line 1063: fnd_msg_pub.add;

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;
1067: end if;

Line 1081: fnd_msg_pub.add;

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
1085: FROM pn_locations_all

Line 1092: fnd_msg_pub.add;

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;
1096: else

Line 1119: fnd_msg_pub.add;

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;
1123:

Line 1154: fnd_msg_pub.add;

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;
1158:

Line 1167: fnd_msg_pub.add;

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:
1171: -- Check that the equipment type of the eqp item is 1

Line 1180: fnd_msg_pub.add;

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
1184: THEN

Line 1187: fnd_msg_pub.add;

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;
1191:

Line 1203: fnd_msg_pub.add;

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;
1207: -- End of validation for prod org, equipment item, and eqp serial number

Line 1216: fnd_msg_pub.add;

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:
1220: end if;

Line 1227: fnd_msg_pub.add;

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:
1231: end if;

Line 1242: FND_MSG_PUB.Add;

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:
1246: END;