DBA Data[Home] [Help]

APPS.EAM_ITEM_ACTIVITIES_PUB dependencies on FND_MSG_PUB

Line 133: FND_MSG_PUB.ADD;

129: BEGIN
130:
131:
132: FND_MESSAGE.SET_NAME ('EAM', ERROR);
133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;
135: END;
136:
137: --funcation to validate if the provided lookup code is present forthe specified type.

Line 155: fnd_msg_pub.add;

151:
152: if l_count = 0
153: then
154: fnd_message.set_name('EAM', P_MSG);
155: fnd_msg_pub.add;
156: RAISE fnd_api.g_exc_error;
157: end if;
158: END;
159:

Line 180: fnd_msg_pub.add;

176:
177: if l_count = 0
178: then
179: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
180: fnd_msg_pub.add;
181: RAISE fnd_api.g_exc_error;
182: end if;
183: END;
184:

Line 194: fnd_msg_pub.add;

190: then
191: if not EAM_COMMON_UTILITIES_PVT.validate_boolean_flag(p_flag)
192: then
193: fnd_message.set_name('EAM', p_msg);
194: fnd_msg_pub.add;
195: RAISE fnd_api.g_exc_error;
196: end if;
197: end if;
198: end;

Line 226: fnd_msg_pub.add;

222: end if;
223:
224: if l_count = 0 then
225: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_ID');
226: fnd_msg_pub.add;
227: RAISE fnd_api.g_exc_error;
228: end if;
229:
230: END;

Line 257: fnd_msg_pub.add;

253: END IF;
254:
255: if (l_count = 0) then
256: fnd_message.set_name('EAM', 'EAM_INVALID_INVENTORY_ITEM');
257: fnd_msg_pub.add;
258: RAISE fnd_api.g_exc_error;
259: end if;
260: end validate_inventory_item_id;
261:

Line 271: fnd_msg_pub.add;

267:
268: if nvl(p_tmpl_flag, 'N') = 'Y' and p_serial_number is not null
269: then
270: fnd_message.set_name('EAM', 'EAM_IAA_SERIAL_NUMBER_NOT_NULL');
271: fnd_msg_pub.add;
272: RAISE fnd_api.g_exc_error;
273: end if;
274:
275: if nvl(p_tmpl_flag, 'N') = 'N' and p_serial_number is null

Line 278: fnd_msg_pub.add;

274:
275: if nvl(p_tmpl_flag, 'N') = 'N' and p_serial_number is null
276: then
277: fnd_message.set_name('EAM', 'EAM_IAA_SERIAL_NUMBER_NULL');
278: fnd_msg_pub.add;
279: RAISE fnd_api.g_exc_error;
280: end if;
281:
282: if nvl(p_tmpl_flag, 'N') = 'N'

Line 290: fnd_msg_pub.add;

286: where cii.serial_number = p_serial_number;
287:
288: if (l_count = 0) then
289: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
290: fnd_msg_pub.add;
291: RAISE fnd_api.g_exc_error;
292: end if;
293: end if;
294: END validate_serial_number;

Line 348: FND_MSG_PUB.Add;

344: )
345: then
346: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
347: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_error_message);
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_ERROR;
350: end if;
351:
352: end validate_dff_segments;

Line 380: fnd_msg_pub.add;

376: x_act_assoc_id := -1;
377: WHEN TOO_MANY_ROWS THEN
378: fnd_message.set_name('EAM', 'EAM_DATA_CORRUPT');
379: fnd_message.set_token('TABLE_NAME', 'MTL_EAM_ASSET_ACTIVITIES');
380: fnd_msg_pub.add;
381: RAISE fnd_api.g_exc_error;
382: END;
383:
384:

Line 485: FND_MSG_PUB.initialize;

481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: END IF;
483: -- Initialize message list if p_init_msg_list is set to TRUE.
484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
485: FND_MSG_PUB.initialize;
486: END IF;
487: -- Initialize API return status to success
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:

Line 498: fnd_msg_pub.add;

494:
495: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
496: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
497: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
498: fnd_msg_pub.add;
499: RAISE fnd_api.g_exc_error;
500: else
501: l_creation_organization_id := P_ORGANIZATION_ID;
502: end if;

Line 520: fnd_msg_pub.add;

516: x_msg_data => x_msg_data);
517: if l_boolean = 0
518: then
519: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
520: fnd_msg_pub.add;
521: RAISE fnd_api.g_exc_error;
522: end if;
523: end if;
524:

Line 528: fnd_msg_pub.add;

524:
525:
526: IF ((p_class_code IS NOT NULL or p_owningdepartment_id IS NOT NULL) AND p_organization_id IS NULL) THEN
527: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
528: fnd_msg_pub.add;
529: RAISE fnd_api.g_exc_error;
530: END IF;
531:
532: -- Bug # 3441956

Line 566: fnd_msg_pub.add;

562:
563: if p_start_date_active>p_end_date_active
564: then
565: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
566: fnd_msg_pub.add;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:
570: if p_last_service_start_date > p_last_service_end_date

Line 573: fnd_msg_pub.add;

569:
570: if p_last_service_start_date > p_last_service_end_date
571: then
572: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
573: fnd_msg_pub.add;
574: RAISE fnd_api.g_exc_error;
575: END IF;
576:
577: if p_prev_service_start_date > p_prev_service_end_date

Line 580: fnd_msg_pub.add;

576:
577: if p_prev_service_start_date > p_prev_service_end_date
578: then
579: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
580: fnd_msg_pub.add;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583:
584: if p_last_scheduled_start_date > p_last_scheduled_end_date

Line 587: fnd_msg_pub.add;

583:
584: if p_last_scheduled_start_date > p_last_scheduled_end_date
585: then
586: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
587: fnd_msg_pub.add;
588: RAISE fnd_api.g_exc_error;
589: END IF;
590:
591:

Line 595: fnd_msg_pub.add;

591:
592: if p_prev_scheduled_start_date > p_prev_scheduled_end_date
593: then
594: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
595: fnd_msg_pub.add;
596: RAISE fnd_api.g_exc_error;
597: END IF;
598:
599: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');

Line 633: fnd_msg_pub.add;

629: --------------------------------------------------------------------------------------------
630: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
631: (p_inventory_item_id is null)) THEN
632: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
633: fnd_msg_pub.add;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN

Line 639: fnd_msg_pub.add;

635: END IF;
636:
637: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
638: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');
639: fnd_msg_pub.add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643: l_org_id := p_organization_id;

Line 915: x_msg_count := FND_MSG_PUB.count_msg;

911: p_pm_last_service_tbl => p_pm_last_service_tbl,
912: p_actv_assoc_id => l_actv_assoc_id
913: );
914:
915: x_msg_count := FND_MSG_PUB.count_msg;
916: IF x_msg_count > 0 THEN
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919: END IF;

Line 927: FND_MSG_PUB.get

923: IF FND_API.To_Boolean( p_commit ) THEN
924: COMMIT WORK;
925: END IF;
926: -- Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.get
928: ( p_msg_index_out => x_msg_count ,
929: p_data => x_msg_data
930: );
931: EXCEPTION

Line 935: FND_MSG_PUB.get

931: EXCEPTION
932: WHEN FND_API.G_EXC_ERROR THEN
933: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
934: x_return_status := FND_API.G_RET_STS_ERROR ;
935: FND_MSG_PUB.get
936: ( p_msg_index_out => x_msg_count ,
937: p_data => x_msg_data
938: );
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 942: FND_MSG_PUB.get

938: );
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: FND_MSG_PUB.get
943: ( p_msg_index_out => x_msg_count ,
944: p_data => x_msg_data
945: );
946: WHEN OTHERS THEN

Line 949: IF FND_MSG_PUB.Check_Msg_Level

945: );
946: WHEN OTHERS THEN
947: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.Check_Msg_Level
950: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME ,

Line 950: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

946: WHEN OTHERS THEN
947: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.Check_Msg_Level
950: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME ,
954: l_api_name

Line 952: FND_MSG_PUB.Add_Exc_Msg

948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.Check_Msg_Level
950: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME ,
954: l_api_name
955: );
956: END IF;

Line 957: FND_MSG_PUB.get

953: ( G_PKG_NAME ,
954: l_api_name
955: );
956: END IF;
957: FND_MSG_PUB.get
958: ( p_msg_index_out => x_msg_count ,
959: p_data => x_msg_data
960: );
961: END INSERT_ITEM_ACTIVITIES;

Line 1064: FND_MSG_PUB.initialize;

1060: END IF;
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062:
1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068: -- API body

Line 1078: fnd_msg_pub.add;

1074:
1075: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
1076: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
1077: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: else
1081: l_creation_organization_id := P_ORGANIZATION_ID;
1082: end if;

Line 1100: fnd_msg_pub.add;

1096: x_msg_data => x_msg_data);
1097: if l_boolean = 0
1098: then
1099: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1100: fnd_msg_pub.add;
1101: RAISE fnd_api.g_exc_error;
1102: end if;
1103: end if;
1104:

Line 1108: fnd_msg_pub.add;

1104:
1105:
1106: IF ((p_class_code IS NOT NULL or p_owningdepartment_id IS NOT NULL) AND p_organization_id IS NULL) THEN
1107: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1108: fnd_msg_pub.add;
1109: RAISE fnd_api.g_exc_error;
1110: END IF;
1111:
1112: -- Bug # 3441956

Line 1143: fnd_msg_pub.add;

1139:
1140: if p_start_date_active>p_end_date_active
1141: then
1142: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
1143: fnd_msg_pub.add;
1144: RAISE fnd_api.g_exc_error;
1145: END IF;
1146:
1147: if p_last_service_start_date > p_last_service_end_date

Line 1150: fnd_msg_pub.add;

1146:
1147: if p_last_service_start_date > p_last_service_end_date
1148: then
1149: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1150: fnd_msg_pub.add;
1151: RAISE fnd_api.g_exc_error;
1152: END IF;
1153:
1154: if p_prev_service_start_date > p_prev_service_end_date

Line 1157: fnd_msg_pub.add;

1153:
1154: if p_prev_service_start_date > p_prev_service_end_date
1155: then
1156: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1157: fnd_msg_pub.add;
1158: RAISE fnd_api.g_exc_error;
1159: END IF;
1160:
1161: if p_last_scheduled_start_date > p_last_scheduled_end_date

Line 1164: fnd_msg_pub.add;

1160:
1161: if p_last_scheduled_start_date > p_last_scheduled_end_date
1162: then
1163: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1164: fnd_msg_pub.add;
1165: RAISE fnd_api.g_exc_error;
1166: END IF;
1167:
1168:

Line 1172: fnd_msg_pub.add;

1168:
1169: if p_prev_scheduled_start_date > p_prev_scheduled_end_date
1170: then
1171: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1172: fnd_msg_pub.add;
1173: RAISE fnd_api.g_exc_error;
1174: END IF;
1175:
1176: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');

Line 1211: fnd_msg_pub.add;

1207: --------------------------------------------------------------------------------------------
1208: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
1209: (p_inventory_item_id is null)) THEN
1210: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
1211: fnd_msg_pub.add;
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214:
1215: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN

Line 1217: fnd_msg_pub.add;

1213: END IF;
1214:
1215: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
1216: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');
1217: fnd_msg_pub.add;
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;
1220:
1221: l_org_id := p_organization_id;

Line 1338: fnd_msg_pub.add;

1334: l_id);
1335:
1336: IF (l_id = -1) THEN
1337: fnd_message.set_name('EAM', 'EAM_ITEM_ACT_REC_NOT_FOUND');
1338: fnd_msg_pub.add;
1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341:
1342:

Line 1433: x_msg_count := FND_MSG_PUB.count_msg;

1429: p_pm_last_service_tbl => p_pm_last_service_tbl,
1430: p_actv_assoc_id => P_ACTIVITY_ASSOCIATION_ID
1431: );
1432:
1433: x_msg_count := FND_MSG_PUB.count_msg;
1434: IF x_msg_count > 0 THEN
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: END IF;

Line 1445: FND_MSG_PUB.get

1441: IF FND_API.To_Boolean( p_commit ) THEN
1442: COMMIT WORK;
1443: END IF;
1444: -- Standard call to get message count and if count is 1, get message info.
1445: FND_MSG_PUB.get
1446: ( p_msg_index_out => x_msg_count ,
1447: p_data => x_msg_data
1448: );
1449: EXCEPTION

Line 1453: FND_MSG_PUB.get

1449: EXCEPTION
1450: WHEN FND_API.G_EXC_ERROR THEN
1451: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1452: x_return_status := FND_API.G_RET_STS_ERROR ;
1453: FND_MSG_PUB.get
1454: ( p_msg_index_out => x_msg_count ,
1455: p_data => x_msg_data
1456: );
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1460: FND_MSG_PUB.get

1456: );
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1458: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1460: FND_MSG_PUB.get
1461: ( p_msg_index_out => x_msg_count ,
1462: p_data => x_msg_data
1463: );
1464: WHEN OTHERS THEN

Line 1467: IF FND_MSG_PUB.Check_Msg_Level

1463: );
1464: WHEN OTHERS THEN
1465: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1467: IF FND_MSG_PUB.Check_Msg_Level
1468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg
1471: ( G_PKG_NAME ,

Line 1468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1464: WHEN OTHERS THEN
1465: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1467: IF FND_MSG_PUB.Check_Msg_Level
1468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg
1471: ( G_PKG_NAME ,
1472: l_api_name

Line 1470: FND_MSG_PUB.Add_Exc_Msg

1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1467: IF FND_MSG_PUB.Check_Msg_Level
1468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg
1471: ( G_PKG_NAME ,
1472: l_api_name
1473: );
1474: END IF;

Line 1475: FND_MSG_PUB.get

1471: ( G_PKG_NAME ,
1472: l_api_name
1473: );
1474: END IF;
1475: FND_MSG_PUB.get
1476: ( p_msg_index_out => x_msg_count ,
1477: p_data => x_msg_data
1478: );
1479: END update_item_activities;