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 114: FND_MSG_PUB.initialize;

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

Line 187: fnd_msg_pub.add;

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

Line 192: 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;
196:

Line 256: FND_MSG_PUB.Add;

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

Line 269: FND_MSG_PUB.Add;

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

Line 365: FND_MSG_PUB.Add;

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

Line 376: FND_MSG_PUB.Count_And_Get

372: IF FND_API.To_Boolean( p_commit ) THEN
373: COMMIT WORK;
374: END IF;
375: -- Standard call to get message count and if count is 1, get message info.
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count ,
378: p_data => x_msg_data
379: );
380: EXCEPTION

Line 384: FND_MSG_PUB.Count_And_Get

380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO Insert_Asset_Number_Pub;
383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: FND_MSG_PUB.Count_And_Get
385: ( p_count => x_msg_count ,
386: p_data => x_msg_data
387: );
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 391: FND_MSG_PUB.Count_And_Get

387: );
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: ROLLBACK TO Insert_Asset_Number_Pub;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count ,
393: p_data => x_msg_data
394: );
395: WHEN OTHERS THEN

Line 398: IF FND_MSG_PUB.Check_Msg_Level

394: );
395: WHEN OTHERS THEN
396: ROLLBACK TO Insert_Asset_Number_Pub;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level
399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg
402: ( G_PKG_NAME ,

Line 399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

395: WHEN OTHERS THEN
396: ROLLBACK TO Insert_Asset_Number_Pub;
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level
399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg
402: ( G_PKG_NAME ,
403: l_api_name

Line 401: FND_MSG_PUB.Add_Exc_Msg

397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level
399: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg
402: ( G_PKG_NAME ,
403: l_api_name
404: );
405: END IF;

Line 406: FND_MSG_PUB.Count_And_Get

402: ( G_PKG_NAME ,
403: l_api_name
404: );
405: END IF;
406: FND_MSG_PUB.Count_And_Get
407: ( p_count => x_msg_count ,
408: p_data => x_msg_data
409: );
410: END Insert_Asset_Number;

Line 516: FND_MSG_PUB.initialize;

512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: -- Initialize message list if p_init_msg_list is set to TRUE.
515: IF FND_API.to_Boolean( p_init_msg_list ) THEN
516: FND_MSG_PUB.initialize;
517: END IF;
518: -- Initialize API return status to success
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520: -- API body

Line 623: FND_MSG_PUB.Add;

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

Line 636: FND_MSG_PUB.Add;

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

Line 658: FND_MSG_PUB.Add;

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

Line 737: FND_MSG_PUB.Count_And_Get

733: IF FND_API.To_Boolean( p_commit ) THEN
734: COMMIT WORK;
735: END IF;
736: -- Standard call to get message count and if count is 1, get message info.
737: FND_MSG_PUB.Count_And_Get
738: ( p_count => x_msg_count ,
739: p_data => x_msg_data
740: );
741: EXCEPTION

Line 745: FND_MSG_PUB.Count_And_Get

741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: ROLLBACK TO Update_Asset_Number_Pub;
744: x_return_status := FND_API.G_RET_STS_ERROR ;
745: FND_MSG_PUB.Count_And_Get
746: ( p_count => x_msg_count ,
747: p_data => x_msg_data
748: );
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 752: FND_MSG_PUB.Count_And_Get

748: );
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO Update_Asset_Number_Pub;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: FND_MSG_PUB.Count_And_Get
753: ( p_count => x_msg_count ,
754: p_data => x_msg_data
755: );
756: WHEN OTHERS THEN

Line 759: IF FND_MSG_PUB.Check_Msg_Level

755: );
756: WHEN OTHERS THEN
757: ROLLBACK TO Update_Asset_Number_Pub;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: IF FND_MSG_PUB.Check_Msg_Level
760: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
761: THEN
762: FND_MSG_PUB.Add_Exc_Msg
763: ( G_PKG_NAME ,

Line 760: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

756: WHEN OTHERS THEN
757: ROLLBACK TO Update_Asset_Number_Pub;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: IF FND_MSG_PUB.Check_Msg_Level
760: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
761: THEN
762: FND_MSG_PUB.Add_Exc_Msg
763: ( G_PKG_NAME ,
764: l_api_name

Line 762: FND_MSG_PUB.Add_Exc_Msg

758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759: IF FND_MSG_PUB.Check_Msg_Level
760: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
761: THEN
762: FND_MSG_PUB.Add_Exc_Msg
763: ( G_PKG_NAME ,
764: l_api_name
765: );
766: END IF;

Line 767: FND_MSG_PUB.Count_And_Get

763: ( G_PKG_NAME ,
764: l_api_name
765: );
766: END IF;
767: FND_MSG_PUB.Count_And_Get
768: ( p_count => x_msg_count ,
769: p_data => x_msg_data
770: );
771: END Update_Asset_Number;

Line 861: fnd_msg_pub.add;

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

Line 887: fnd_msg_pub.add;

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

Line 906: fnd_msg_pub.add;

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

Line 926: fnd_msg_pub.add;

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

Line 945: fnd_msg_pub.add;

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

Line 958: fnd_msg_pub.add;

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

Line 971: fnd_msg_pub.add;

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

Line 984: fnd_msg_pub.add;

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

Line 1005: fnd_msg_pub.add;

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

Line 1020: fnd_msg_pub.add;

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

Line 1031: fnd_msg_pub.add;

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

Line 1049: fnd_msg_pub.add;

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

Line 1060: fnd_msg_pub.add;

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

Line 1087: fnd_msg_pub.add;

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

Line 1122: fnd_msg_pub.add;

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

Line 1135: fnd_msg_pub.add;

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

Line 1148: fnd_msg_pub.add;

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

Line 1155: fnd_msg_pub.add;

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

Line 1171: fnd_msg_pub.add;

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

Line 1184: fnd_msg_pub.add;

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

Line 1195: fnd_msg_pub.add;

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

Line 1210: FND_MSG_PUB.Add;

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